Oracle PL/SQL Language Pocket Reference, Second Edition

Index

Symbols

-- (double hyphen), specifying single-line comments, Comments

/* and */, specifying multiline comments, Comments

A

AGGREGATE USING keyword, Compiling stored PL/SQL programs

ALTER TYPE statement, Changing Object Types , Changing Object Types

anchored declarations, Anchored Declarations

AS LANGUAGE JAVA clause, Java Language Integration, Publishing Java to PL/SQL

assigning records, Record Assignment

associative arrays, Collections, Collections

adding/removing elements, Adding and Removing Elements

initializing, Initializing Collections

syntax for declaring, Declaring a Collection

AUTHID keyword, Compiling stored PL/SQL programs

autonomous transactions, Pragmas , Autonomous Transactions

B

BFILE datatype, LOB Datatypes

binary integer datatypes, Numeric datatypes

BLOB datatype, LOB Datatypes

block structure in PL/SQL, Block Structure

body, package, Package Structure , Referencing Package Elements

BOOLEAN datatype, Boolean datatype

Boolean literals, Boolean, Numeric, and String Literals

bulk binds and collections, Bulk Binds, Bulk Binds

C

CASE expressions, CASE expression (Oracle9i)

CASE statements, CASE statement (Oracle9i)

CAST pseudo-function, Collection Pseudo-Functions

character datatypes, Character datatypes

character set in PL/SQL, PL/SQL Character Set

CLOB datatype, LOB Datatypes

collections

adding/removing elements, Adding and Removing Elements

bulk binds and, Bulk Binds, Bulk Binds

declaration syntax for, Declaring a Collection

initializing, Initializing Collections

methods for, Collection ...