Oracle Database 11g PL/SQL Programming
- 14h 29m
- Michael McLaughlin
- Oracle Press
- 2008
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 programs
- Use 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
About the Author
Michael McLaughlin is a professor at BYU—Idaho in the Computer Information Technology Department of the Business and Communication College. He is also the founder of Techtinker.com.
Michael worked at Oracle Corporation for over eight years in consulting, development, and support. He is the inventor of the ATOMS transaction architecture (U.S. Patents #7,206,805 and #7,290,056). The patents are assigned to Oracle Corporation.
Prior to his tenure at Oracle Corporation, Michael worked as an Oracle developer, systems and business analyst, and DBA beginning with Oracle 6. He is the author of Oracle Database 10g Express Edition PHP Web Programming. He is also the co-author of Oracle Database AJAX & PHP Web Application Development, Oracle Database 10g PL/SQL Programming, and Expert Oracle PL/SQL.
In this Book
-
Oracle PL/SQL Overview
-
PL/SQL Basics
-
Language Fundamentals
-
Control Structures
-
Error Management
-
Functions and Procedures
-
Collections
-
Large Objects
-
Packages
-
Triggers
-
Dynamic SQL
-
Intersession Communication
-
External Procedures
-
Object Types
-
Java Libraries
-
Web Application Development
