ORACLE SQL AND PL/SQL GUIDE TILL 10GR2 - LAXMI PUBLICATION

ABOUT THE BOOK:

This book has expanded the following features in sql & pl/sql

Sql reference for Hierarchical query, data constraints

Sql function to advance query

Sql relational model

Database concepts with physical database structure, database transaction and SCN

Pl/sql syntax and variables, data types control structure cursor, reference cursors, records and exception handling with new features of 10G in details to develop robust application.

Discuss multidimensional collection type for associate array, nested table and varray with collection methods.

Exploit native dynamic sql and bulk binding with new features available in 10gR2

Exploit the power of pl/sql with the help of stored procedure, function and package dealt with definer and invoker right model and remote dependency to develop real time application easily. Enforce complex data constraints by means of DML trigger, Instead of trigger, user events and system events trigger.

Discuss and analyze 10gR2 new feature conditional compilation in depth and find its usage in previous version to have version independent application to take full benefit of new features.

29 tips and technique to boost pl/sql performance

Develop debugging technique to know where the bottleneck in the application is and extended the same to tracing pl/sql application.

Discuss in depth object-oriented features of pl/sql