Oracle PL/SQL Language Pocket Reference 4e - Softcover

Feuerstein, Steven; Pribyl, Bill; Dawes, Chip

Softcover

ISBN 10: 0596514042 ISBN 13: 9780596514044

Publisher: O′Reilly, 2007

Synopsis

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 handling
• Records, procedures, functions, triggers, and packages
• Calling PL/SQL functions in SQL
• Compilation 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.

About this title

About the Author

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including "Oracle PL/SQL Programming" and "Oracle PL/SQL Best Practices" (both O'Reilly). He has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as PL/SQL Evangelist for Quest Software. His Oracle PL/SQL Best Practices column is one of the most popular pages on the Oracle Technology Network and he writes regularly for Oracle Magazine.Bill Pribyl is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, one of Bill's current nonbillable titles include Webmaster for his neighborhood civic club.Chip Dawes has been building and maintaining systems on relational databases since 1988 and with Oracle since 1990. Currently a consultant with D&D Technologies, a Chicago consultancy, he works with, lectures on, and writes about Oracle database administration, client server application development, and Unix system administration.

Edition details

• Publisher: O′Reilly
• Publication date: 2007
• Language: English
• ISBN 10: 0596514042
• ISBN 13: 9780596514044
• Binding: Paperback
• Edition number: 4
• Number of pages: 1770