Oracle Database 11g PL/SQL Programming Workbook

Ramp Up Your PL/SQL Programming Skills

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, and sample code from the book is available for download. 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




For a complete list of Oracle Press titles, visit www.OraclePressBooks.com