Generic

Oracle9i Database New Features
Release 1 (9.0.1)
Oracle9i Database New Features
PL/SQL Improvements

PL/SQL User's Guide and Reference
Release 9.0.1
What's New in PL/SQL?
Oracle9i New Features in PL/SQL

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
What's New in Supplied PL/SQL Packages and Types?

Native Compilation

Oracle9i Application Developer's Guide - Fundamentals
Release 1 (9.0.1)
Using Procedures and Packages
Compiling PL/SQL Procedures for Native Execution
Generic description.

PL/SQL User's Guide and Reference
Release 9.0.1
Tuning PL/SQL Applications
Compiling PL/SQL Code for Native Execution

PL/SQL User's Guide and Reference
Release 9.0.1
Tuning PL/SQL Applications
Limitations of Native Compilation
Continuation of above.

Oracle9i Database Reference
Release 1 (9.0.1)
Initialization Parameters, 157 of 220
PLSQL_COMPILER_FLAGS

Cursor Subqueries

PL/SQL User's Guide and Reference
Release 9.0.1
6 Interaction Between PL/SQL and Oracle
Using Cursor Subqueries

Multilevel Collections

Oracle9i Database New Features
Release 1 (9.0.1)
2 Oracle9i Database New Features
SQL and PL/SQL Improvements

PL/SQL User's Guide and Reference
Release 9.0.1
What's New in PL/SQL?
Multilevel Collections

PL/SQL User's Guide and Reference
Release 9.0.1
5 PL/SQL Collections and Records
Using Multilevel Collections

Bulk Binds

Oracle9i Application Developer's Guide - Fundamentals
Release 1 (9.0.1)
9 Using Procedures and Packages
Overview of Bulk Binds

PL/SQL User's Guide and Reference
Release 9.0.1
5 PL/SQL Collections and Records
Reducing Loop Overhead for Collections with Bulk Binds

PL/SQL User's Guide and Reference
Release 9.0.1
5 PL/SQL Collections and Records
How Do Bulk Binds Improve Performance?

PL/SQL User's Guide and Reference
Release 9.0.1
11 Native Dynamic SQL
Using Bulk Dynamic SQL

PL/SQL User's Guide and Reference
Release 9.0.1
12 Tuning PL/SQL Applications
Improving PL/SQL Performance with Bulk Binds

Pipelined, Parallelized Table Functions

Oracle9i Database Concepts
Release 1 (9.0.1)
16 SQL, PL/SQL, and Java
Pipelined Table Functions
Parallel Execution of Table Functions

Oracle9i Application Developer's Guide - Fundamentals
Release 1 (9.0.1)
9 Using Procedures and Packages
Returning Large Amounts of Data from a Function

PL/SQL User's Guide and Reference
Release 9.0.1
8 PL/SQL Subprograms
Accepting and Returning Multiple Rows with Table Functions

Secure Application Roles

Oracle9i Application Developer's Guide - Fundamentals
Release 1 (9.0.1)
What's New in Application Development?
Secure Application Roles

Oracle9i Database Concepts
Release 1 (9.0.1)
25 Privileges, Roles, and Security Policies
Secure Application Roles [1]
Secure Application Roles [2]

Oracle9i Security Overview
Release 1 (9.0.1)
2 Protecting Data Within the Database
Secure Application Roles
9 Oracle9i Security Products and Features
Secure Application Role

Oracle9i Application Developer's Guide - Fundamentals
Release 1 (9.0.1)
11 Database Security Overview for Application Developers
Creating Secure Application Roles

Oracle9i Database Administrator's Guide
Release 1 (9.0.1)
23 Establishing Security Policies
End-User Security

Oracle9i Database Administrator's Guide
Release 1 (9.0.1)
25 Managing User Privileges and Roles
Role Authorization by an Application

SQL*Plus User's Guide and Reference
Release 9.0.1
Security, 4 of 5
Disabling SET ROLE

Support for Inhertiance

PL/SQL User's Guide and Reference
Release 9.0.1
10 PL/SQL Object Types
Overview of PL/SQL Type Inheritance

CASE Statement

PL/SQL User's Guide and Reference
Release 9.0.1
4 PL/SQL Control Structures
CASE Statement
Searched CASE Statement

PL/SQL User's Guide and Reference
Release 9.0.1
2 Fundamentals of PL/SQL
CASE Expressions
Searched CASE Expression

Support for HTTP Cookies

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
78 UTL_HTTP
UTL_HTTP
Example: Retrieving and Restoring Cookies

XMLType

Oracle9i Database New Features
Release 1 (9.0.1)
2 Oracle9i Database New Features
XMLType

Oracle9i Database Concepts
Release 1 (9.0.1)
13 System-Provided Datatypes
XML Datatypes

Oracle9i Application Developer's Guide - Fundamentals
Release 1 (9.0.1)
3 Selecting a Datatype
Representing XML Data

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
71 DBMS_XMLGEN
72 DBMS_XMLQUERY
73 DBMS_XMLSAVE

Oracle9i XML Reference
Release 1 (9.0.1)
14 XML Support

Oracle9i SQL Reference
Release 1 (9.0.1)
Basic Elements of Oracle SQL, 2 of 10
URI Datatypes

DBMS_METADATA

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
28 DBMS_METADATA

Oracle9i Database Administrator's Guide
Release 1 (9.0.1)
21 General Management of Schema Objects
Using PL/SQL Packages to Display Information About Schema Objects