Oracle

The database design paradigm is a very important concept, but this important degree is only suitable for reference. Using the database design paradigm, you can make the data table better to save the data, because the reasonable design, if the data

Constraint is a kind of mandatory rule which is added on the table, and it is an important means to guarantee the integrality of data.When you insert data into a table, or modify data in a table, you must meet the conditions specified by the

A view is a very important database object in the form of a normal table, and we can query the data from the view.In fact, it is a virtual table built on a table that does not store real data in the view, but simply saves a SELECT statement, and

DeclareJobno number;BeginDbms_job.submit (Jobno,' P_dosomething; ',--whatTo_date (' 20090101020000 ', ' yyyy-mm-dd hh24:mi:ss '),--next_date, can not be filledInterval = ' TRUNC (sysdate) + 1 +2/(+) '--' Interval time string '--interval, key

The system global Area (SGA), also called the shared global zone. 1. Data buffer (Cache):Used to store data read from a disk data file for all users to share. After the user modifies the data, the modified data is first saved in the database

1. Query the current date and timeSelect from dual;2. Check the last day of this monthSelect from dual;3. How many months before and after querySelect add_months (sysdate, from dual;4. Check the specific date of the week of the following week

and ((#{protocolstarttime} >= t.protocol_start_time and #{protocolstarttime} (#{protocolstarttime} = t.protocol_end_time) OR(#{protocolendtime} >= t.protocol_start_time and #{protocolendtime} )]]>This will determine your incoming start time and end

The user presses, the string decomposition in the Oracle programming can use in the word, the word parsing, then may implement the word search merger, is the basic code.The code below, the author retains ownership.Create or Replace function

Configuration of swap on Oracle serverOn Oracle servers, setting the appropriate swap size can improve Oracle's performance, and for Oracle 11g, the physical memory on the Oracle server and the swap size to be set are as follows:If the physical

Index typeBinary tree index, B-tree index (B-tree Indexes)The B-Tree index is one of the most used indexes. By default, the index created is a B-tree index. Use the B-tree structure to store the index. B-Tree bottom is leaf node, leaf node holds

--Create a sequenceCreateSequence Zonecode_seq Start with 1Increment by 1; --Create a triggerCreate or Replace TriggerZonecode_trigger beforeInsert onorg_hospitalzone_dict forEach rowbegin SelectZonecode_seq.nextval into: New. Hosp_zonecode

1. Installed Oracle 12c Client for Windows, received from colleagues, said to be 64-bit, but I did not find contains 64 such file name or the contents of 64 bits.The 64-bit version of plsqldev1104, which was obtained from colleagues, also has a 936 3

---Stop Job 25 is an established jobbeginDbms_job.broken ( -, True); Commit; End; --Start JobbeginDbms_job.run ( -); Commit; End; --Delete Job beginDbms_job.remove ( -); Commit; End; --View Execution ResultsSelect * fromTest_jobOrder

Article source home/database/oracle Database Online Documentation 11g Release 2 (11.2)/Database administration http://docs.oracle.com/cd/E11882_01/server.112/e40540/intro.htm#CNCPT001 Oracle Database Introduction Schema In

1.Oracle provides privileged users, such as SYSDBA or Sysoper, who are primarily used to perform maintenance operations on the database, such as starting a database, shutting down a database, establishing a database, and performing operations such

Once the Oracle database is installed, it will bring a Scott account, which will have an EMP table 1. The command to unlock the Scott account alter the user Scott account unlock;2. Modify the password for the Scott accounts alter user Scott

SQL syntax Exercise: 1, select all employees in department 30 select * from EMP where deptno=30;2, lists the clerk's name, number and department number select ename, empno, deptno from Empwhere job=u Pper (' clerk '); 3, find the employee with a

The method for handling the trigger and the concluding remarks during the trigger in a graph of Oracle, And the oracle trigger A trigger in Oracle is a very useful technology. Unlike stored procedures and functions, stored procedures and

Tnsnames. ora file description, tnsnames. ora description Directory location Unix:$ORACLE_HOME/network/admin WINDOW:%ORACLE_HOME%\network\admin Set the corresponding environment variable: TNS_ADMIN Example of tnsname. ora File Content-- Server Load

Go to: Query oracle slow sessions and SQL, oraclesession -- Query the slowest SQL statement Select * from (Select parsing_user_id, executions, sortsCommand_type, disk_reads, SQL _text from v $ sqlarea order by disk_reads desc) Where rownum -- Query