Create bookmark
Oracle PL/SQL Language Pocket Reference
A guide to Oracle's PL/SQL language fundamentals
Notes
Please login to add notes
- Contents
-
+
Oracle PL/SQL Language Pocket Reference
- + Introduction
- + 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
-
+
Named Program Units
- Procedures
- Functions
-
+
Parameters
- Datatype
- Mode
- Default values
- Parameter-passing notations
- Local programs
- Program overloading
- Forward declarations
- Table functions
- Compiling stored PL/SQL programs
- Compiler warnings (Oracle Database 10g)
- The optimizing compiler (Oracle Database 10g)
- Performing native compilation of PL/SQL
- Privileges and stored PL/SQL
- + Triggers
- + Packages
- + Calling PL/SQL Functions in SQL
-
+
Oracle’s Object-Oriented Features
- + Collections
- + External Procedures
- + Java Language Integration
- + Regular Expressions (Oracle Database 10g)
- Reserved Words
- Index
While it's good to have a book with all the answers--like your trusty copy of Oracle PL/SQL Programming-- how often do you need all the answers? More likely, you just need a reminder, a quick answer to a problem you're up against. For these times, nothing's handier than the new edition of the Oracle PL/SQL Language Pocket Reference by PL/SQL experts Stephen Feuerstein, Bill Pribyl, and Chip Dawes. Newly updated for Oracle10g, this little book is always at the ready for the quick problem solving you need.
The 3rd edition of this popular mini-reference boils down the most vital information from Oracle PL/SQL Programming into a handy guide to PL/SQL basics. The book includes fundamental language elements, such as block structure, identifiers, variables, datatypes, ad declarations; statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/QL functions in SQL.
And there's more. This concise guide also covers Oracle objects, collections, external procedures, Java integration, and new Oracle 10g elements like regular expressions, compile-time warnings, more implicit conversion, FORALL support for non-consecutive indexes, and more. The amount of valuable information packed into this slim volume--intelligently arranged for quick accessibility--make this an indispensable reference for new and seasoned Oracle database developers alike.
O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the 3rd edition of Oracle PL/SQL Language Pocket Reference is the book you'll want to have.
Test the closed alpha on paperc.com
Book Details
Authors
Steven Feuerstein, Bill Pribyl, and Chip Dawes
Categories
Computers > Web > Page Design
Publishers
Publication year : 2004
License: All rights reserved ©
Times read: 217

