Description
McGraw Hill Oracle 11G Pl/Sql Programming Workbook by MCLAUGHLIN and MICHAEL
PL/SQL, the - Oracle’s primary tool for manipulating the database. This proprietary version of SQL, designed and optimized for Oracle databases, is a powerful tool in interacting with the database and working with the data. This book covers the various new enhancements made to PL/SQL in Oracle Database 11g. It briefly covers the various features of PL/SQL and provides a lot of examples and exercises for further clarification and practice. Oracle Database 11g PL/SQL Programming Workbook is divided into four parts. The first part comprises of an overview of Oracle development architecture. It then covers PL/SQL basics, transaction scope add error management. The second part, PL/SQL Programming, covers functions, procedures, collections, triggers, packages, and objects, The third part covers advanced topics like dynamic SQL and external files. The fourth part has four five appendix sections, covering additional material. These cover Wrapping PL/SQL, PL/SQL hierarchical profiler, PL/Scope, and PL/SQL Built-In packages and types. The fifth appendix section provides answers to chapter exercises. Oracle Database 11g PL/SQL Programming Workbook shows how to work with PL/SQL data types, structures, cursors, and blocks and how to create and use procedures and functions and packages. It also shows how to create and use object types, and how to use external tables to support online transaction processing and data warehousing. At the end of each chapter, a set of mastery exercises are given to reinforce the concepts covered. The answers to these mastery exercises are given in the final appendix. This comprehensive workbook from Oracle Press is designed to provide practical experience in developing PL/SQL programs, for all levels of users - from the novice to the seasoned PL/SQL programmer.