Skip Headers
Oracle® Database SQL Language Reference
11g Release 2 (11.2)

Part Number E17118-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

What's New in the SQL Language Reference?

This section describes new features of Oracle Database 11g and provides pointers to additional information.

For information on features that were new in earlier versions of Oracle Database, refer to the documentation for the earlier release.

Oracle Database 11g Release 2 (11.2.0.2) New Features in the SQL Language Reference

New Features in the SQL Language Reference

The following top-level SQL statements are enhanced in this release:

Oracle Database 11g Release 2 (11.2.0.1) New Features in the SQL Language Reference

Structural Changes in the SQL Language Reference

A number of sections of this book that were make up primarily of PL/SQL were moved to Oracle Database PL/SQL Language Reference in Oracle Database 11g Release 1. Please refer to "Structural Changes in the SQL Language Reference" for details on this migration of material.

New Features in the SQL Language Reference

The following top-level SQL statements are new or enhanced in this release:

The following built-in functions are new or enhanced in this release:

The following miscellaneous features are new or enhanced in this release:

Oracle Database 11g Release 1 New Features in the SQL Language Reference

Structural Changes in the SQL Language Reference

A number of SQL statements are constructed almost entirely of PL/SQL elements. Those statements continue to appear in this reference, but the bulk of their syntax and semantics has been moved to Oracle Database PL/SQL Language Reference. The following table contains links to both the abbreviated SQL syntax and semantics in this book and to the full syntax and semantics in Oracle Database PL/SQL Language Reference.

Abbreviated SQL Section Full Syntax and Semantics
CREATE FUNCTION CREATE FUNCTION
CREATE PACKAGE CREATE PACKAGE
CREATE PACKAGE BODY CREATE PACKAGE BODY
CREATE PROCEDURE CREATE PROCEDURE
CREATE TRIGGER CREATE TRIGGER
CREATE TYPE CREATE TYPE
CREATE TYPE BODY CREATE TYPE BODY
ALTER FUNCTION ALTER FUNCTION
ALTER PACKAGE ALTER PACKAGE
ALTER PROCEDURE ALTER PROCEDURE
ALTER TRIGGER ALTER TRIGGER
ALTER TYPE ALTER TYPE

New Features in the SQL Language Reference

The following top-level SQL statements are new or enhanced in this release:

The following SQL built-in functions have been added or enhanced:

The following miscellaneous changes have been made: