Oracle PL/SQL Language Pocket Reference, 3/e

Chip Dawes, Steven Feuerstein, Bill Pribyl

  • 出版商: O'Reilly
  • 出版日期: 2004-04-01
  • 售價: $550
  • 貴賓價: 9.5$523
  • 語言: 英文
  • 頁數: 156
  • 裝訂: Paperback
  • ISBN: 0596006802
  • ISBN-13: 9780596006808
  • 相關分類: OracleSQL





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.

Table of Contents:

     PL/SQL Language Fundamentals
           PL/SQL Character Set
           Boolean, Numeric, and String Literals
           Numeric Literals
           Datetime Interval Literals
           Block Structure
     Variables and Program Data
           Scalar Datatypes
           NLS Character Datatypes
           LOB Datatypes
           Implicit Datatype Conversions
           NULLs in PL/SQL
           Declaring Variables
           Anchored Declarations
           Programmer-Defined Subtypes
     Conditional and Sequential Control
           Conditional Control Statements
           Sequential Control Statements
           Simple Loop
           Numeric FOR Loop
           Cursor FOR Loop
           WHILE Loop
           REPEAT UNTIL Loop Emulation
           EXIT Statement
           Loop Labels
     Database Interaction
           Transaction Management
           Autonomous Transactions
     Cursors in PL/SQL
           Explicit Cursors
           Implicit Cursors
           Dynamic Cursors
           Cursor Variables
           Cursor Expressions
     Exception Handling
           Declaring Exceptions
           Raising Exceptions
     Records in PL/SQL
           Declaring Records
           Referencing Fields of Records
           Assigning Records
           DML and Records
           Nested Records
     Named Program Units
           Creating Triggers
           Trigger Predicates
           DML Events
           DDL Events
           Database Events
           Package Structure
           Referencing Package Elements
           Package Data
           SERIALLY_REUSABLE Pragma
           Package Initialization
     Calling PL/SQL Functions in SQL
           Calling a Function
           Requirements and Restrictions
           Calling Packaged Functions in SQL
           Column/Function Name Precedence
     Oracle's Object-Oriented Features
           Object Types
           Type Inheritance
           Methods in Subtypes
           Manipulating Objects in PL/SQL and SQL
           Upcasting and Downcasting
           Changing Object Types
           Declaring a Collection
           Initializing a Collection
           Adding and Removing Elements
           Nested Table Functions
           Collection Methods
           Collections and Privileges
           Nested Collections
           Bulk Binds
     External Procedures
           Creating an External Procedure
     Java Language Integration
           Publishing Java to PL/SQL
           Data Dictionary
     Regular Expressions (Oracle Database 10g)
           Match Modifiers
     Reserved Words