Sql & Pl/sql For Oracle 10g Black Book

0.0

The book brings to you the complete, latest account of SQL and PL/SQL for Oracle. It gifts you two things - 1st, it upgrades your knowledge on the subject and 2nd, the innumerable, exciting examples help you build a better skill in SQL and PL/SQL. This comprehensive reference will help you learn the entire spectrum of SQL - from Views to Cube and Roll Up; from Case Expressions to Variances and Corelation - and PL/SQL - from Collections to ObjectTypes; from error handling to Triggers; from Object views to Rollback segments; from UNDO tablespace to Expression filter and many more. Table of Contents` Introduction to SQL Set Operations SQL Operators Aggregate Functions and Group by Clause Updating and Deleting Data in Existing Table (DML) Views Assignment - I Assignment - II Advanced Queries Integrity Constraints Analytical Queries Understanding ROLLUP and CUBE Understanding Joins Scalar Subqueries Case Expressions Multitable Insert and Merge Regular Expression Statistical Functions Model Queries SQL Quiz PL/SQL Program Features PL/SQL Datatypes Understanding Control Structure Interaction with Oracle Collections and Records LOB, BFILE and DBMS_LOB Objects and Objects Types Sample Programs - I Sample Programs - II Error Handling Subprograms in PL/SQL Package Trigger (Database) Autonomous Transaction Important PL/SQL Packages Object Views Transaction Processing in Oracle Locking in Oracle Rollback Segments UNDO Tablespace Invoker Rights and NOCOPY Clause Dependency Tracking in Oracle FalshBack Queries Sequence PL/SQL Wrapper Oracle Expression Filter Server Model for Billing Entry System Security and Auditing PL/SQL Questions