2

New Features of Oracle SQL

In this chapter:

  • What are the new features of Oracle SQL in Oracle Database 10g?

  • What were the new features of Oracle SQL in Oracle Database 9i?

  • What PL/SQL improvements are there?

  • How is XML development better supported?

  • What’s new in Oracle SQL utilities?

This chapter takes a bird’s-eye view of Oracle SQL changes in both Oracle Database 10g and Oracle Database 9i. Without further ado, let’s get started with Oracle Database 10g.

2.1 New Features in Oracle Database 10g

Oracle Database 10g contains the following SQL and PL/SQL features.

2.1.1 Oracle SQL Improvements in Oracle Database 10g

  • Oracle documentation states that case sensitivity is no longer required for filtering and sorting in SQL statements. Proving ...

Get Oracle SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.