Oracle PL/SQL Language Pocket Reference, 5th Edition

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, the Oracle PL/SQL Language Pocket Reference will 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 bestselling Oracle PL/SQL Programming.

Table of Contents

• PL/SQL Language Fundamentals
• Variables and Program Data
• Conditional and Sequential Control
• Loops
• Database Interaction
• Cursors in PL/SQL
• Exception Handling
• Records in PL/SQL
• Collections in PL/SQL
• Built-in Functions and Packages
• Stored Procedures and Functions
• Triggers
• Packages
• Calling PL/SQL Functions in SQL
• Object-Oriented Features
• Compilation
• Java Language Integration