| |
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 ISBN 9788131807255
|
| |
Pages : 264
|