Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
---|---|---|---|---|---|
Searching... | 30000010215532 | QA76.9.D3 M34 2008 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Design Feature-Rich PL/SQL Applications
Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.
Create, debug, and manage Oracle-driven PL/SQL programsUse PL/SQL structures, delimiters, operators, variables, and statements
Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routines, object types, large objects, and secure files
Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit
Author Notes
Michael McLaughlin is a professor of Computer Information Technology at BYU-Idaho, the author of Oracle Database 10g Express Edition PHP Web Programming, and coauthor of the previous edition of this book. He has been working with PL/SQL since release 1.
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 and 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 and Keywords |
Appendix J PL/SQL Built-in Functions |
Index |