Description
An update to the popular bible for PL/SQL developers, this second edition updates the Oracle8 material and includes chapters on Oracle8 object types, object views, collections, external procedures, and large object types and functions. It also covers new strategies for tuning, tracing, and debugging PL/SQL programs and offers many new programs on the accompanying disk.
Read More
The first edition of Oracle PL/SQL Programming quickly became an indispensable reference for both novice and experienced PL/SQL developers. Packed with examples and recommendations, it helped everyone using PL/SQL (from the Oracle Forms developer to the database administrator) make the most of this powerful language.Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and complexities of the language. This new edition updates the original book for Oracle8, adding chapters describing the new PL/SQL object features (object types, collections, object views, and external procedures). The second edition also contains a much-requested chapter on tuning PL/SQL, as well as expanded discussions of debugging and tracing PL/SQL execution.The book comes with a companion diskette containing the Companion Utilities Guide for Oracle PL/SQL Programming, an online tool developed by RevealNet, Inc. The online guide contains more than 100 file of source code and documentation prepared by the authors.Even if you've already read the first edition of Oracle PL/SQL Programming, you'll find an enormous amount of new and revised information in this second edition and on its companion diskette. If you're new to PL/SQL, you'll soon find yourself on the road to mastery.NOTE: To make room for the new material, some summaries and code from the first edition have been moved to the companion disk.Oracle PL/SQL Programming is divided into seven parts:Foreword PrefacePart I: Programming in PL/SQL1. Introduction to PL/SQL 2. PL/SQL Language Fundamentals 3. Effective Coding StylePart II: PL/SQL Language Elements4. Variables and Program Data 5. Conditional and Sequential Control 6. Database Interaction and Cursors 7. Loops 8. Exception Handlers 9. Records in PL/SQL 10.PL/SQL TablesPart III: Built-in Functions and Packages11. Character Functions 12. Date Functions 13. Numeric, LOB, and Miscellaneous Functions 14. Conversion FunctionsPart IV: Modular Code15. Procedures and Functions 16. Packages 17. Calling Stored PL/SQL Functions from SQLPart V: PL/SQL Oracle8 Features18. Object Types 19. Nested Tables and VARRAYs 20. Object Views 21. External ProceduresPart VI: Making PL/SQL Programs Work22. Code Design Tips 23. Managing Code in the Database 24. Debugging PL/SQL 25. Tracing PL/SQL 26. Tuning PL/SQLPart VII: AppendixesA. What's on the Companion Disk? B. Calling Stored Procedures from PL/SQL Version 1.1 C. Built-in Packages
Read Less