Prepare to Upgrade ORACLE to learn new 12C features

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.