Oracle Database 11g PL/SQL Programming Workbook
Mike John McLaughlin, John Harper · CERN Document Server (European Organization for Nuclear Research) · 2010
Skill-building exercises that amp up programming skills This new workbook format supplements and builds on the bestseller, Oracle Database 11g PL/SQL Programming. You'll learn essential Oracle PL/SQL skills through hands-on, real-world labs, extensive examples, exercises, and projects. Oracle Database 11g PL/SQL Programming Workbook can be used as a stand-alone learning tool or in combination with the programming book to reinforce the material. All of the enhancements and improvements made to PL/SQL with the release of Oracle Database 11g are covered in the book. Even experienced Oracle professionals will benefit from this practical guide. Table of contents Part I. PL/SQL FundamentalsCh 1. Oracle Development OverviewCh 2. PL/SQL BasicsCh 3. Transaction ScopeCh 4. Error ManagementPart II. PL/SQL ProgrammingCh 5. FunctionsCh 6. ProceduresCh 7. CollectionsCh 8. PackagesCh 9. TriggersCh 10. ObjectsPart III. PL/SQL Advanced ProgrammingCh 11. Native Dynamic SQLCh 12. External FilesCh 13. Java LibrariesCh 14. External LibrariesAppendicesA. Wrapping PL/SQLB. PL/SQL Hierarchical ProfilerC. PL/ScopeD. PL/SQL Built-Ins