true
Oracle SQL and PL/SQL Guide till 10gR2
Author: Asim Chowdhury
Brand: Laxmi Publications Pvt. Ltd
ISBN: 9788131807255-
₹295
Sold Out
Description of product
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 About The Author: Asim Chowdhury : Born on Dec. 29th 1978, he did his schooling in Midnapore, West Bengal and graduated from REC, Surat, presently known as National Institute of Technology. While at school and college, apart from studies, he was into the National Cadet Corps ? NCC and spent a good enough time in inter-college debate competition
Renting Guidelines
Specification of Products
| Brand | Laxmi Publications Pvt. Ltd |
