Oracle Database 11g PL/SQL Programming
By Michael McLaughlin
Date Mar 21, 2008
835 pages
ISBN 0071494456 / 9780071494458Design Feature-Rich PL/SQL Applications
Deliver dynamic, client/server PL/SQL applications with consultant superintendence from an Oracle programming professional. With full coverage of a ultimate facilities as well as tools, Oracle Database 11g PL/SQL Programming lays out any subject to one side minute explanations, cut-and-paste syntax examples, as well as real-world box studies. Access as well as cgange database information, erect absolute PL/SQL statements, govern in effect queries, as well as muster bulletproof security. You’ll additionally sense how to exercise C, C++, as well as Java procedures, Web-enable your database, cut growth time, as well as optimize performance.
Create, debug, as well as conduct Oracle-driven PL/SQL programs
Use PL/SQL structures, delimiters, operators, variables, as well as statements
Identify as well as discharge errors regulating PLSQL_WARNINGS as well as difference handlers
Work with functions, procedures, packages, collections, as well as triggers
Define as well as muster varray, nested table, as well as associative form interpretation types
Handle outmost routines, intent types, vast objects, as well as secure files
Communicate in between together sessions regulating DBMS_ALERT as well as DBMS_PIPE
Call outmost procedures by Oracle Net Services as well as PL/SQL wrappers
Integrate inner as well as server-side Java category libraries regulating Oracle JVM
Develop strong Web applications regulating PL/SQL Gateway as well as Web Toolkit
Table of contents
Part I: PL/SQL Fundamentals
Chapter 1. Oracle PL/SQL Overview
Chapter 2. PL/SQL Basics
Chapter 3. Language Fundamentals
Chapter 4. Control Structures
Chapter 5. Error Management
Part II: PL/SQL Programming
Chapter 6. Functions as well as Procedures
Chapter 7. Collections
Chapter 8. Large Objects
Chapter 9. Packages
Chapter 10. Triggers
Part III: PL/SQL Advanced Programming
Chapter 11. Dynamic SQL
Chapter 12. Intersession Communication
Chapter 13. External Procedures
Chapter 14. Object Types
Chapter 15. Java Libraries
Chapter 16. Web Application Development
Part IV: Appendixes
Appendix A. Oracle Database Administration Primer
Appendix B. Oracle Database SQL Primer
Appendix C. PHP Primer
Appendix D. Oracle Database Java Primer
Appendix E. Regular Expression Primer
Appendix F. Wrapping PL/SQL Code Primer
Appendix G. PL/SQL Hierarchical Profiler Primer
Appendix H. PL/Scope
Appendix I. PL/SQL Reserved Words as well as Keywords
Appendix J. PL/SQL Built-in Functions
Index
Michael McLaughlin is a highbrow of Computer Information Technology during BYU-Idaho, a writer of Oracle Database 10g Express Edition PHP Web Programming, as well as coauthor of a prior book of this book. He has been operative with PL/SQL given recover 1.
No comments:
Post a Comment