Oracle Pl/SQL Language Pocket Reference: A Guide to Oracle's Pl/SQL Language Fundamentals

✍ Scribed by Feuerstein, Steven;Pribyl, Bill;Dawes, Chip

• Publisher: O'Reilly Media
• Year: 2015
• Tongue: English
• Leaves: 189
• Category: Library

✦ Synopsis

Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c.

Whether you're a developer or database administrator, when you need answers quickly, theOracle PL/SQL Language Pocket Referencewill save you hours of frustration with concise summaries of:


Fundamental language elements, such as block structure, datatypes, and declarations
Statements for program control, cursor management, and exception handling
Records, procedures, functions, triggers, and packages
Execution of PL/SQL functions in SQL
Compilation options, object-oriented features, collections, and Java integration
This handy pocket reference is a perfect companion to Steven Feuerstein and Bill Pribyl's bestsellingOracle PL/SQL Programming.

✦ Table of Contents

Copyright......Page 4
Table of Contents......Page 5
Introduction......Page 7
PL/SQL Language Fundamentals......Page 8
Identifiers......Page 9
Boolean, Numeric, and String Literals......Page 10
Numeric Literals......Page 11
Datetime Interval Literals......Page 12
Delimiters......Page 13
Comments......Page 14
Pragmas......Page 15
Block Structure......Page 16
Variables and Program Data......Page 18
Scalar Datatypes......Page 19
LOB Datatypes......Page 25
NULLs in PL/SQL......Page 26
Declaring Variables......Page 27
Anchored Declarations......Page 28
Programmer-Defined Subtypes......Page 29
Conditional Control Statements......Page 30
Sequential Control Statements......Page 34
Numeric FOR Loop......Page 36
Cursor FOR Loop......Page 37
WHILE Loop......Page 38
CONTINUE Statement......Page 39
Database Interaction......Page 41
Transaction Management......Page 42
Autonomous Transactions......Page 45
Explicit Cursors......Page 46
Implicit Cursors......Page 50
Native Dynamic SQL......Page 54
DBMS_SQL......Page 56
Cursor Variables......Page 57
Cursor Expressions......Page 59
Exception Handling......Page 60
Declaring Exceptions......Page 61
Raising Exceptions......Page 63
Propagation......Page 64
Declaring Records......Page 68
Referencing a Record’s Fields......Page 69
Assigning Records......Page 70
Records and DML......Page 71
Collections in PL/SQL......Page 72
Declaring a Collection......Page 75
Initializing a Collection......Page 76
Adding and Removing Elements......Page 77
Nested Table Functions......Page 78
Collection Methods......Page 81
Bulk Binds......Page 85
Built-in Functions......Page 90
Built-in Regular Expression Functions......Page 105
Stored Procedures and Functions......Page 111
Procedures......Page 112
Functions......Page 113
Parameters......Page 114
Local Programs......Page 118
Program Overloading......Page 119
Forward Declarations......Page 120
Table Functions......Page 121
Function Result Cache......Page 122
Privileges and Stored PL/SQL......Page 124
Triggers......Page 126
Creating Triggers......Page 127
DML Events......Page 131
Compound DML Triggers......Page 132
Database Events......Page 134
Package Structure......Page 135
Package Data......Page 137
SERIALLY_REUSABLE Pragma......Page 138
Package Initialization......Page 139
Calling a Function......Page 140
Column Name Versus Function Name Precedence......Page 142
Object Types......Page 143
Methods......Page 146
Methods in Subtypes......Page 150
Manipulating Objects in PL/SQL and SQL......Page 152
Upcasting and Downcasting......Page 153
Changing Object Types......Page 156
Compiling Stored PL/SQL Programs......Page 158
Conditional Compilation......Page 161
Compiler Warnings......Page 164
Optimizing Compiler......Page 167
Performing Native Compilation of PL/SQL......Page 169
Java Language Integration......Page 170
Example......Page 171
Publishing Java to PL/SQL......Page 172
Data Dictionary......Page 174
Index......Page 175

✦ Subjects

Reference;Computer Science;Programming;Science;Technology