• Increased Column Size Limits
The setting is called MAX_STRING_SIZE. There are two values for this:
STANDARD – The original sizes - 4k bytes
EXTENDED – The new larger sizes - 32K byts of record
You can't rollback the changes.
• Approx Count
SELECT COUNT(DISTINCT NAME) FROM Employee;
Select APPROX_COUNT_DISTINCT(NAME) From Employee;
• Row Limiting with a Top-N Query
FETCH FIRST|NEXT|PERCENT
Select * From Employee;
SELECT * FROM Employee FETCH FIRST 5 ROWS ONLY; --FETCH FIRST
SELECT * FROM Employee
OFFSET 5 ROWS FETCH NEXT 8 ROWS ONLY; --NEXT
SELECT * FROM Employee
FETCH FIRST 100 PERCENT ROWS ONLY; --PERCENT
• JSON Support in the Database
• Lateral Clause for Inline Views
SELECT ID, NAME, DEPTNAME
FROM EMPLOYEE E,
LATERAL(SELECT DEPTNAME
FROM DEPARTMENT D WHERE D.DEPTID = E.DEPTID);
• New Optimization – Partial Join Evaluation
IN
EXISTS
• Cascading Truncate
Select * From REPORT_SUMMARY_DETAIL; --Parent Table
Select * From REPORT_SUMMARY_METER_DETAIL; --Child Table
TRUNCATE TABLE REPORT_SUMMARY_DETAIL CASCADE;
Home Page
https://tipsfororacle.blogspot.com/
#GoLearningPoint
#GoLearningPoint
