Oracle PL/SQL Language Pocket Reference

Larger Cover

By Bill Pribyl, Steven Feuerstein, Chip Dawes

Publisher: O'Reilly Media

Released: April 1999

Pages: 99

This pocket reference provides quick-reference information that will help you use Oracle's PL/SQL language. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling book, Oracle PL/SQL Programming, and includes coverage of the latest version of Oracle, Oracle8i.

Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL provides procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools. It offers a myriad of data types, and such features as cursors, loops, conditional and sequential control statements, exception handlers, records, tables, and constructs for developing modular code (functions, procedures, and packages). Originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. Now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object-oriented capabilities.

The book on which this pocket reference is based, Oracle PL/SQL Programming, filled a huge gap in the Oracle market, providing developers with a single, comprehensive guide to building applications with PL/SQL -- and building them the right way. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. The book is packed with strategies, code architectures, tips, techniques, and fully realized code. The second edition of the book updated the text with the new Oracle8 PL/SQL features, including object types, collections, external procedures, and large object data types and functions.

The pocket reference boils down the most vital information from the large (nearly 1000 pages) book into an accessible quick reference that summarizes the basics of PL/SQL -- its block structure, fundamental language elements (e.g., identifiers, declarations, defaults), data structures (including Oracle8 objects), and statements for program control, loops, exception handling, and database access. It also covers the the basics of using Oracle's procedures, functions, and packages, and the latest features for Oracle8i.

Chapter 1 Oracle PL/SQL Language Pocket Reference
1. Introduction
2. Acknowledgments
3. Conventions
4. PL/SQL Language Fundamentals
5. Variables and Program Data
6. Conditional and Sequential Control
7. Loops
8. Database Interaction and Cursors
9. Cursors in PL/SQL
10. Exception Handling
11. Records in PL/SQL
12. Named Program Units
13. Triggers
14. Packages
15. Calling PL/SQL Functions in SQL
16. Oracle8 Objects
17. Collections
18. External Procedures
19. Java Language Integration

Title:

Oracle PL/SQL Language Pocket Reference

By:

Bill Pribyl, Steven Feuerstein, Chip Dawes

Publisher:

O'Reilly Media

Formats:

Print:

April 1999

Pages:

Print ISBN:

978-1-56592-457-4

| ISBN 10:

1-56592-457-6

Bill Pribyl

Bill Pribyl, author, teacher, and software consultant,is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all published by O'Reilly & Associates. An Oracle user since 1986, Bill has consulted on many aspects of using Oracle products. He recently spearheaded PLNet.org, a Web-based repository where developers can share open source PL/SQL.

View Bill Pribyl's full profile page.
Steven Feuerstein

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

View Steven Feuerstein's full profile page.
Chip Dawes

Chip Dawes has been building and maintaining systems on relational databases since 1988 and with Oracle since 1990. He is currently a consultant with D&D Technologies, a Chicago consultancy. He enjoys working with, lecturing on, and writing about Oracle database administration, client server application development, and Unix system administration. Chip is an Oracle Certified Professional and earned computer science and aerospace engineering degrees from St. Louis University.

View Chip Dawes's full profile page.