Oracle PL/SQL Language Pocket Reference

Steven Feuerstein, Bill Pribyl, Chip Dawes9780596514044, 0596514042

Table of contents :
Oracle PL/SQL Language Pocket Reference, Fourth Edition……Page 1
Contents……Page 4
Acknowledgments……Page 10
PL/SQL Character Set……Page 11
Identifiers……Page 12
Boolean, Numeric, and String Literals……Page 13
Numeric Literals……Page 14
Delimiters……Page 15
Pragmas……Page 17
Block Structure……Page 18
Variables and Program Data……Page 20
Numeric datatypes……Page 21
Character datatypes……Page 23
Datetime datatypes……Page 24
BOOLEAN datatype……Page 26
LOB Datatypes……Page 27
Declaring Variables……Page 28
Default values……Page 30
Anchored Declarations……Page 31
Conditional Control Statements……Page 32
IF-THEN-ELSIF combination……Page 33
CASE statement……Page 34
CASE expression……Page 35
GOTO……Page 36
Loops……Page 37
Numeric FOR Loop……Page 38
WHILE Loop……Page 39
CONTINUE Statement (Oracle Database 11g)……Page 40
Loop Labels……Page 42
Transaction Management……Page 43
SET TRANSACTION……Page 44
LOCK TABLE……Page 45
Autonomous Transactions……Page 46
Explicit Cursors……Page 47
Opening explicit cursors……Page 48
Closing explicit cursors……Page 49
Explicit cursor attributes……Page 50
Implicit Cursors……Page 51
SELECT FOR UPDATE clause……Page 52
WHERE CURRENT OF clause……Page 53
Dynamic Cursors……Page 54
DBMS_SQL……Page 55
SQL Injection and Bind Variables……Page 56
Cursor Variables……Page 57
Cursor Expressions……Page 58
Exception Handling……Page 59
Declaring Exceptions……Page 60
Raising Exceptions……Page 62
Propagation……Page 63
SQLCODE, SQLERRM, and DBMS_UTILITY.FORMAT_ CALL_STACK……Page 64
Records in PL/SQL……Page 65
Declaring Records……Page 66
Assigning Records……Page 67
Records and DML……Page 68
Nested Records……Page 69
Collections in PL/SQL……Page 70
Declaring a Collection……Page 72
Initializing a Collection……Page 73
Nested Table Functions……Page 74
Collection Methods……Page 77
Bulk Binds……Page 80
Built-in Functions……Page 84
Conversion functions……Page 85
String functions……Page 87
Numeric functions……Page 91
Datetime functions……Page 94
Built-in Regular Expression Functions……Page 96
Metacharacters……Page 97
REGEXP_LIKE……Page 98
REGEXP_SUBSTR……Page 99
REGEXP_REPLACE……Page 101
Built-in Packages……Page 102
Stored Procedures and Functions……Page 106
Procedures……Page 107
Functions……Page 108
Datatype……Page 109
Mode……Page 110
Parameter-passing notations……Page 111
Local Programs……Page 112
Program Overloading……Page 113
Table Functions……Page 115
Function Result Cache……Page 116
Triggers……Page 118
Creating Triggers……Page 119
DML Events……Page 123
Compound DML Triggers……Page 124
Packages……Page 126
Package Structure……Page 127
SERIALLY_REUSABLE Pragma……Page 129
Package Initialization……Page 130
Calling PL/SQL Functions in SQL……Page 131
Calling a Function……Page 132
Calling Packaged Functions in SQL……Page 133
Object-Oriented Features……Page 134
Object Types……Page 135
Member methods……Page 137
Constructor methods……Page 138
Comparison methods……Page 139
Methods in Subtypes……Page 141
Manipulating Objects in PL/SQL and SQL……Page 142
Upcasting and Downcasting……Page 144
REF operator……Page 145
DEREF operator……Page 146
Changing Object Types……Page 147
Compilation……Page 148
Compiling Stored PL/SQL Programs……Page 149
Conditional Compilation……Page 151
Compiler Warnings……Page 154
Optimizing Compiler……Page 156
Performing Native Compilation of PL/SQL……Page 158
Oracle Database 10g……Page 159
Oracle Database 11g……Page 160
Java Language Integration……Page 161
Example……Page 162
Publishing Java to PL/SQL……Page 163
Data Dictionary……Page 164
Index……Page 166