| 000 | 02191nam a2200169Ia 4500 | ||
|---|---|---|---|
| 005 | 20250130104724.0 | ||
| 008 | 240411s9999||||xx |||||||||||||| ||und|| | ||
| 020 |
_c529.00 _a978-8177227109 |
||
| 040 | _aSCA | ||
| 082 |
_a005.74 _bDES |
||
| 100 | _aDeshpande,P.S | ||
| 245 | 0 | _aSQL and PL/SQL for Oracle 10g Black Book | |
| 260 |
_bDreamtech Press _c2009 _aNew Delhi |
||
| 300 | _a980p. | ||
| 500 | _ahe 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 | ||
| 942 | _cBK | ||
| 999 |
_c49062 _d49062 |
||