O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required