"VV Square"building, Plot.No.TS 710/1b1 & 2B1, CMC Ward No 18, Moka road, Gandhinagar, Ballari-583 101. 583101 Bellari IN
trendypaper
"VV Square"building, Plot.No.TS 710/1b1 & 2B1, CMC Ward No 18, Moka road, Gandhinagar, Ballari-583 101. Bellari, IN
+918050151380 https://www.trendypaper.com/s/5b1a00c581a9afd8ff765190/ms.settings/5256837ccc4abf1d39000001/5b928defbda50e15d4c76434-480x480.png" [email protected]
9788131807255- 5fc6524559051a6981cc17d9 Oracle SQL and PL/SQL Guide till 10gR2 https://www.trendypaper.com/s/5b1a00c581a9afd8ff765190/5fc6524659051a6981cc1806/aawqykb.jpg 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 9788131807255-
out of stock INR 295
Laxmi Publications Pvt. Ltd
1 1
Oracle SQL and PL/SQL Guide till 10gR2

Oracle SQL and PL/SQL Guide till 10gR2

Be the first to review this product

Author: Asim Chowdhury

Brand: Laxmi Publications Pvt. Ltd

ISBN: 9788131807255-
₹295
Sold Out
Sold By: trendypaper

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

Related products

User reviews

  0/5
Post Review