Oracle

Oracle Flash Back Technology1.Flashback Database2.Flashback Drop3.Flashback Table4.Flashback Query1.Flashback Database (recovery with flashback log)Description: The Oracle Flashback database feature allows SQL statements to be Flashback to databases

I. Stored procedures and FunctionsStored procedures: Encapsulation of a moduleFunctions: Functions are almost the same as stored proceduresDifference:function must return a value via the return keywordStored procedures:Return value is not

When the Linux server inside the virtual machine is installed with Oracle (the specific installation method is mentioned in the previous blog), how to connect it? What happens during the connection?1, first we download instantclient compression

1 Oracle Data Types2 Character Type3 Char[(Size[byte|char])]: Maximum 2000 bytes, default 1 bytes4 varchar2(Size[Byte|char]): Maximum 4000 bytes5 nchar[(size)]: Multi-byte encoding (Unicode) Maximum of 2000 bytes6 nvarchar2 (size): Maximum is 4000

Simply record the process: (in fact, the guidance of the help page is very simple and clear) Download installation files OracleXEUniv.exe, run directly; Most of the steps go directly to the boot, note where the password is required, this

Transferred from: http://www.hellodb.net/2009/12/hash_partition.htmlIn the interview often ask a question, please list the hash in the database internal application, the principle of hash is simple, but it can be said in the database is everywhere.

Grand Court-notes1, the establishment of stored procedures. Shaped like:Create or replace procedure Deletetableprocedures isBeginDelete Post_day;Delete Post_foul_realtime;CommitEnd Deletetableprocedures;2, the establishment of timed operations,

Download 3 things first: The link forgot, we look for a1 ora+11+g+r2+server+64bit+for+windows.iso (Oracle installation file)2 Plsql3 oracle64-bit clients Instant client v11.2.0.3.0 (64-bit). exeon the next server, install

one\--Create TABLE SpaceName of CREATE tablespace table spaceDataFile ' E:\oracle\app\userdata\java5space.dbf '--Table space physical file pathSize 5m--Initial sizeAutoextend on-Automatic growth--Create UserCreate user Java5user--usernameIdentified

--Create synonymsCreate synonym t_system_userdepartment for Xtzl. T_system_userdepartment;--Query synonymsSELECT * from SYS. all_synonyms WHERE synonym_name= ' t_system_post ';--Query the synonyms under the current userSELECT * from

Zhang QiweiDate: April 21, 2017Capabilities: Understanding Oracle's backup and recovery mechanisms1. Archive mode and non-archive modeThe Oracle database requires at least two sets of online logs, which will continue to be written to the next set of

Database Additions and deletions: add: INSERT INTO ... values (); Example: INSERT into p_emp values (Sq_emp.nextval, 'Small white','Cleaning',7902, Sysdate, -Null -,0); Commit Notice how many columns there are in the table, and how much of the

CURSOR traversal in Oracle stored procedure, call job timed run1, first use for loopThe For loop is a simpler and more useful method.First of all. It will take its own initiative open and close cursors. Overcomes the annoyance of forgetting to open

Oracle NET1. The client obtains the specific connection information of the server through the @ora10g name to the Tnsname.ora file.2. The client sends a link request to the server via the description in the Tnsname.ora server side3. After the server'

Restore 0.92 database to 1.92, restore time July 131. Query the required control log7-2-7-4 -r-b-L "CNT "(2nd, 3 steps can be parallel)2. Start restoring the control fileAccess to Rman, database up to nomount use Backup files to control file

Below is Oracle's master quote: Oracle Database developers should follow is to do everything they can in SQL. What they cannot does in SQL, they should does in PL +. And what they cannot does in PL/SQL, they should do in whatever language

A tablespace is a logical division of a database, and a table space can only belong to one database.All database objects are stored in the specified table space. But the main storage is the table, so called table space. There is at least one table

Oracle Management:InstanceInstanceRAC (real application cluster) Oracle working environment, one-to-manyInstance1 Instance2\ /DatabaseSGA buffer shared pool share pools are used to cache execution plans for recently executed SQL statementsMain

Often use the database, let him start the words, the boot is too slow, so use the command to start a convenient point.1. Open:Enter CMD in the run, enter the console, Lsnrctl start Enter, prompt to start monitoring after successfulnet start

Analysis of effective cursor management"Thinking Analysis"The ability to interpret cursors as shared run schedules when SQL is not shared. There are two directions to the conventional approach:1. Adjust the size of the shared pool (shared operation