SQL and PL/SQL for Oracle 11g Black Book

This book, sql & pl/sql black book, brings to you the complete, latest account of sql and pl/sql for oracle. It gifts you two things-first, it upgrades your knowledge on the subject; and second the innumerable, exciting examples help you build a better skill in sql and pl/sql. The highlight of the book is a clear yet incisive discussion of the basic features of oracle 9i and the latest advanced features that come with oracle 10g. The in-depth treatment of the subject in a lucid language will give you an enjoyable learning experience as you have always had with our previous books on oracle. Unit - i: sql · 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 unit - ii: pl/sql · pl/sql program features · pl/sql datatypes · understanding control structure · interaction with oracle · collections and records · lob, bfile, and dbms_lob · objects and object 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 · flashback queries · sequence · pl/sql wrapper · oracle expression filter · server model for bill entry system · security and auditing · pl/sql questions