SQL Features include:
• Inheritance, type evolution and dynamic method dispatch are supported in Oracle 9i.
• CASE WHEN statement, ANSI compliant joins, and reserved name versioning is supported. (New ANSI requirements).
• Scrolling cursor support to migrate from non-Oracle databases.
PL/SQL Features include:
• Native compilation.
• An integrated front-end for SQL compilation that supports all SQL syntax changes for SQL embedded in PL/SQL.
Stored procedures written in 3GL languages (PL/SQL, Java, as well as external routines) can utilize SQL parallel query mechanism and can now pipeline (incrementally return) data to the calling SQL statement.
No comments:
Post a Comment