Book description
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.
Table of contents
-
Oracle PL/SQL Language Pocket Reference
-
1. Oracle PL/SQL Language Pocket Reference
- Introduction
- Acknowledgments
- Conventions
- PL/SQL Language Fundamentals
- Variables and Program Data
- Conditional and Sequential Control
- Loops
- Database Interaction and Cursors
- Cursors in PL/SQL
- Exception Handling
- Records in PL/SQL
- Named Program Units
- Triggers
- Packages
- Calling PL/SQL Functions in SQL
- Oracle8 Objects
- Collections
- External Procedures
- Java Language Integration
-
1. Oracle PL/SQL Language Pocket Reference
Product information
- Title: Oracle PL/SQL Language Pocket Reference
- Author(s):
- Release date: April 1999
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781565924574
You might also like
book
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 …
book
Oracle Database 11g PL/SQL Programming
Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming …
book
Oracle RMAN Pocket Reference
Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery …
book
Oracle Advanced PL/SQL Developer Professional Guide
Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book …