Sql & Pl/sql For Oracle 10g Black Book, 2007 Ed details from flipkart

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