Oracle8i Advanced PL/SQL Programming
Published on 16. May 2000
Book
812 pages
978-0-07-212146-9 (ISBN)
Description
PL/SQL (Procedural Language/SQL) is a sophisticated programming language used to access Oracle databases from various platforms. This in-depth guide provides information which will enable the reader to develop robust, Web-enabled PL/SQL applications. It includes full coverage of packages, triggers, dynamic SQL, external routines, objects, and collections with a specific focus on all of the new Oracle8i features and commonly used built-in packages. Strategies for tuning, tracing, and debugging PL/SQL programs are also covered. The CD includes trial versions of five PL/SQL development environments, which include debugging techniques.
More details
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
references
Dimensions
Height: 231 mm
Width: 188 mm
Thickness: 43 mm
Weight
1701 gr
ISBN-13
978-0-07-212146-9 (9780072121469)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
Scott Urman (Foster City, CA) is a senior member of the diagnostic and defect technical staff in the Language Group of Oracle Support Services, where he aids users of Oracle's various language products (PL/SQL, OCI, and the Oracle precompilers). In addition, he reviews Oracle technical documentation, writes white papers on Oracle languages, and makes technical presentations both inside Oracle and at meetings of Oracle User's Groups. Scott is the best-selling author of Oracle Press' Oracle PL/SQL Programming and Oracle8 PL/SQL Programming.
Content
Part I: Introduction and Development Environments. Introduction. PL/SQL Development and Execution Environments. Tracing and Debugging. Part II: Non-Object Features. Creating Subprograms and Packages. Using Subprograms and Packages. Database Triggers. Database Jobs and File I/O. Dynamic SQL. Intersession Communication. External Routines. Additional Oracle8i Features. Part III: Object Features and LOBs. Introduction to Objects. Objects in the Database. Collections. On the CD-ROM. Large Objects. Advanced LOB Topics and DBMS-LOB. Appendices: A: Guide to Supplied Packages. B: PL/SQL Reserved Words. C: The Data Dictionary.