Oracle PL/SQL Language Pocket Reference

by Steven Feuerstein, Bill Pribyl, Chip Dawes

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital PL/SQL information into an accessible summary of: Fundamental language elements (e.g., block structure, datatypes, declarations)Statements for program control, cursor management, and exception handlingRecords, procedures, functions, triggers, and packagesCalling PL/SQL functions in SQLCompilation options, object-oriented features, collections, and Java integration The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages. When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

Genres: Reference, Programming, Geek, Technology

178 pages, Kindle Edition

First published February 1, 2003

Reviews

[Ettore Pasquini · Rating 3 out of 5]

When I was at Oracle, I was asked to code a bunch of stuff in PL/SQL. I knew SQL, but never done anything in PL/SQL. This is the only book I read, and it was enough.