E-Books →Oracle Database 11g PLSQL Programming Workbook (Oracle Press)

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 connectionsWork with data types, structures, blocks, cursors, and PL/SQL semanticsWrite, deploy, and use functions, procedures, and packagesManage transactions and moreUse dynamic SQL statements in real-world applicationsSupport online transaction processing and data warehousing applications with external tablesFind syntax samples and best practices to solve problemsWrite, deploy, and use object types