Oracle Database 11g PL/SQL Programming Workbook
- 6h 15m
- John M. Harper, Michael McLaughlin
- Oracle Press
- 2010
Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered. Even experienced Oracle professionals will benefit from this practical resource.
- Understand the Oracle development architecture and the mechanics of connections
- Work with data types, structures, blocks, cursors, and PL/SQL semantics
- Write, deploy, and use functions, procedures, and packages
- Manage transactions and more
- Use dynamic SQL statements in real-world applications
- Support online transaction processing and data warehousing applications with external tables
- Find syntax samples and best practices to solve problems
- Write, deploy, and use object types
About the Authors
Michael McLaughlin is a professor at Brigham Young University-Idaho in the Computer Information Technology Department of the Business and Communication School. He is the author of Oracle Database 11g PL/SQL Programming and other titles.
John M. Harper is a database professional with 10 years of Oracle experience. He is currently a senior lead engineer at the Church of Jesus Christ of Latter-day Saints.
In this Book
-
Oracle Development Overview
-
PL/SQL Basics
-
Transaction Scope
-
Error Management
-
Functions
-
Procedures
-
Collections
-
Packages
-
Triggers
-
Objects
-
Dynamic SQL
-
External Files
