SQL and PL/SQL for Oracle 10g Black Book
- New Delhi Dreamtech Press 2009
- 980p.
he 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. · 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