search for books and compare prices
cover image
Oracle Pl/SQL Programming
The price is the lowest for any condition, which may be new or used; other conditions may also be available. Rental copies must be returned at the end of the designated period, and may involve a deposit.
Jump down to see edition details for: Paperback
Bibliographic Detail
Publisher Oreilly & Associates Inc
Publication date September 1, 1997
Pages 987
Binding Paperback
Edition 2 pap/cdr
Book category Adult Non-Fiction
ISBN-13 9781565923355
ISBN-10 1565923359
Dimensions 1.75 by 7 by 9.25 in.
Weight 3.25 lbs.
Availability§ Out of Print
Original list price $49.95
§As reported by publisher
Summaries and Reviews description: Product Description:

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/SQL

  • 1. Introduction to PL/SQL
  • 2. PL/SQL Language Fundamentals
  • 3. Effective Coding Style
Part II: PL/SQL Language Elements
  • 4. 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 Tables
  • Part III: Built-in Functions and Packages
    • 11. Character Functions
    • 12. Date Functions
    • 13. Numeric, LOB, and Miscellaneous Functions
    • 14. Conversion Functions
    Part IV: Modular Code
    • 15. Procedures and Functions
    • 16. Packages
    • 17. Calling Stored PL/SQL Functions from SQL
    Part V: PL/SQL Oracle8 Features
    • 18. Object Types
    • 19. Nested Tables and VARRAYs
    • 20. Object Views
    • 21. External Procedures
    Part VI: Making PL/SQL Programs Work
    • 22. Code Design Tips
    • 23. Managing Code in the Database
    • 24. Debugging PL/SQL
    • 25. Tracing PL/SQL
    • 26. Tuning PL/SQL
    Part VII: Appendixes
    • A. What's on the Companion Disk?
    • B. Calling Stored Procedures from PL/SQL Version 1.1
    • C. Built-in Packages

    Book cover for 9780596003814 Book cover for 9780596009779 Book cover for 9781565921429 Book cover for 9781565923355
    With Bill Pribyl | 4th edition from Oreilly & Associates Inc (October 1, 2005)
    9780596009779 | details & prices | 1171 pages | 6.75 × 9.00 × 2.00 in. | 3.30 lbs | List price $64.95
    About: For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language.
    With Bill Pribyl | 3 edition from Oreilly & Associates Inc (September 1, 2002)
    9780596003814 | details & prices | 900 pages | 7.00 × 9.25 × 1.50 in. | 2.80 lbs | List price $54.95
    About: Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language.
    The price comparison is for this edition
    With Bill Pribyl | 2 pap/cdr edition from Oreilly & Associates Inc (September 1, 1997)
    9781565923355 | details & prices | 987 pages | 7.00 × 9.25 × 1.75 in. | 3.25 lbs | List price $49.95
    About: The first edition of Oracle PL/SQL Programming quickly became an indispensable reference for both novice and experienced PL/SQL developers.
    Pap/dis edition from Oreilly & Associates Inc (September 1, 1995)
    9781565921429 | details & prices | 6.75 × 9.25 × 1.75 in. | 2.95 lbs | List price $44.95
    About: 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.

    Pricing is shown for items sent to or within the U.S., excluding shipping and tax. Please consult the store to determine exact fees. No warranties are made express or implied about the accuracy, timeliness, merit, or value of the information provided. Information subject to change without notice. is not a bookseller, just an information source.