Prepare to Upgrade ORACLE to learn new 12C features

1. PLSQL performance enhancement: similar to the definition process in anonymous blocks, you can use the WITH statement to define a function in SQL. This method can improve the performance of SQL calls. 2. Defaults improvement: including sequence as the default value; Auto-incrementing column; default value when NULL is explicitly inserted; METADATA-ONLYdefault value refers to

1. PL/SQL Performance Enhancement: similar to the definition process in anonymous blocks, you can use the WITH statement to define a function in SQL. This method can improve the performance of SQL calls. 2. Improved Defaults: including sequence as default value; Auto-incrementing column; Specify default value when NULL is explicitly inserted; METADATA-ONLY default value refers to

1. PL/SQL Performance Enhancement: similar to the definition process in anonymous blocks, you can use the WITH statement to define a function in SQL. This method can improve the performance of SQL calls.

2. improved Defaults: includes a sequence as the default value; Auto-incrementing column; specify the default value when NULL is explicitly inserted; METADATA-ONLY default value refers to the default value specified when a new column is added, and the difference in 11g is that, the default value of 11g must be not null.

3. extend the length limit of multiple data types: Increase the VARCHAR2, NVARCHAR2, and RAW types to 32 K, set compatibility to 12.0.0.0 or above, and set the initialization parameter MAX_ SQL _STRING_SIZE to EXTENDED, this function does not support CLUSTER tables and index organization tables. In the end, this function does not actually change the limitation OF VARCHAR2, but is implemented through clob of out of line.

4. Implement the top n statement: In the SELECT statement, use "FETCH next N rows" or "OFFSET" to specify the first N records or the first percentage of records.

5. Row mode matching: similar to the analysis function, you can perform matching and judgment between lines and perform calculation. The new schema matching statement in SQL is "match_recognize ".

6. Partition Improvement

7. Adaptive execution plan

8. Enhanced statistics

9. Temporary UNDO

10. Data Optimization

11. Application continuity

12. Oracle Pluggable Database

Original article address: Prepare to Upgrade ORACLE to learn new features of 12C. Thank you for sharing it with me.