Oracle9i /Developer: PL/SQL Programming

Joan Casteel

  • 出版商: Thomson
  • 出版日期: 2003-05-09
  • 售價: $980
  • 貴賓價: 9.5$931
  • 語言: 英文
  • 頁數: 560
  • 裝訂: Paperback
  • ISBN: 061915909X
  • ISBN-13: 9780619159092
  • 相關分類: OracleSQL
  • 下單後立即進貨 (約5~7天)




This book offers complete coverage of the subject of programming with PL/SQL, including an introduction to PL/SQL at the beginning up through coverage of advanced topics. Also helps to prepare students for the Oracle9i PL/SQL Programming certification exam.

Table of Contents

1. Introduction to PL/SQL
2. Handling Data in PL/SQL blocks
3. PL/SQL Processing
4. Procedures
5. Functions
6. PL/SQL Packages
7. Program Unit Dependencies
8. Database Triggers
9. Oracle-Supplied Packages
10. Introduction to Dynamic SQL and Object Technology
11. Performance Tuning
A: Tables for Brewbeans Database
B: Procedure Builder
C: TOAD (Tool for Oracle Application Developers)
D: PL/SQL and Oracle9i Developer Forms (available at via the Student Downloads?link on the Web page for this textbook)

iSQL*Plus Users Guide also available at "Student Downloads" page (tutorial on new Oracle tool).


  • Offers full coverage of PL/SQL, from the basics for those new to the language, up through advanced topics, and is perfectly suited for a course on the subject
  • Helps prepare individuals for the new Oracle Certification exam, Oracle9i: Program with PL/SQL (#1Z0-147)
  • Offers hundreds of opportunities for valuable hands-on practice, including step-by-step tutorials as well as review questions, hands-on assignments, and case projects in every chapter
  • Uses SQL*Plus as the tool of choice for hands-on tasks, and includes two debugging appendices dedicated to Procedure Builder and "TOAD" (Tool for Oracle Application Developers)
  • Can be bundled with Course Technology Kit for Oracle9i Software, which includes the Oracle9i Database software.