Database Reference
In-Depth Information
2
New Features of Oracle SQL
In this chapter:
What are the new features of Oracle SQL in Oracle Database 10
g
?
What were the new features of Oracle SQL in Oracle Database 9
i
?
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 Ora-
cle Database 10
g
and Oracle Database 9
i
. Without further ado, let's get
started with Oracle Database 10
g
.
2.1
New Features in Oracle Database 10
g
Oracle Database 10
g
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 this
point is a tuning exercise and does not belong in this topic.
The CONNECT BY clause now allows ancestor-descendant pairs as
opposed to only parent-child pairs. In other words, pairs can be
matched and returned where those pairs are not directly related
within a hierarchy but related from the top to the bottom of a hierar-
chy (see Chapter 13).
Search WWH ::




Custom Search