| Bookmarks |
| *** Interview Questions *** |
| *** Mastering Oracle PL/SQL: Practical Solutions *** |
| Advanced PL/SQL (Oracle DB 10g) (PDF) |
| Analytic functions by Example -- LEAD, LAG, RANK, DENSE_RANK, FIRST... |
| Analytic functions by Example -- LEAD, LAG, RANK, DENSE_RANK, FIRST... (PDF) |
| Application and Networking Architecture |
| Convert XML data into rows and columns using SQL |
| Database Administration |
| Database Specialists - Tutorials and White Papers |
| DBMS_JOB |
| DBMS_SCHEDULER |
| Email From PL/SQL In Oracle9i |
| Handling PL/SQL Errors -- PL/SQL User's Guide and Reference |
| How to Convert Rows to Columns and Back Again with SQL (Aka PIVOT and UNPIVOT) |
| How to Extract xmltype as xml in Oracle |
| LISTAGG function |
| LISTAGG function in 11g release 2 - a built-in function that enables us to perform string aggregation natively |
| Oracle and XML In Action - A Real World Example |
| Oracle Applications Developer's Guide (PDF) |
| Oracle Bitmap Index Techniques |
| Oracle Built-In Functions |
| Oracle Connect By Function |
| Oracle Database -- 2 Day DBA |
| Oracle Database Error Code Explained |
| Oracle Database Installing and Upgrading |
| Oracle Database List of Books -- 10g Release 1 (10.1) |
| Oracle Database List of Books -- 11g Release 2 (11.2) |
| Oracle Database List of Books -- 9i Release 2 (9.2) |
| Oracle Database Master Glossary 11g Release 2 (11.2) |
| ORACLE FAQ'S |
| Oracle Glossary |
| Oracle Interview Questions |
| Oracle PIPE ROW statement |
| Oracle PIPELINED Table Functions -- Akadia |
| Oracle Pipelined Table Functions -- Oracle-Base |
| Oracle Programming with PL/SQL Collections |
| Oracle Row Generator Techniques |
| Oracle WITH Clause |
| OracleŽ Database Concepts 11g Release 2 (11.2) |
| OracleŽ Database Performance Tuning Guide |
| OracleŽ Database PL/SQL Collections and Records -- PL/SQL User's Guide and Reference - Release 2 (9.2) |
| OracleŽ Database PL/SQL FAQ |
| OracleŽ Database PL/SQL Language Reference 11g Release 2 (11.2) |
| OracleŽ Database PL/SQL Optimization and Tuning |
| OracleŽ Database PL/SQL User s Guide and Reference -- 10g Release 1 (PDF) |
| OracleŽ Database PL/SQL User s Guide and Reference -- Release 2 (9.2) |
| OracleŽ Database PL/SQL User's Guide and Reference
10g Release 2 (10.2)
|
| OracleŽ Database SQL Language Reference -- 11g Release 2 (11.2) |
| OracleŽ XML DB Developer's Guide - 10g Release 2 (10.2) |
| OracleŽ XML DB Developer's Guide - Using XMLType |
| Oracle-Base -- Collections |
| Oradev.com - Portal for Oracle Developer |
| Pivot and Unpivot -- Present information in a spreadsheet-type crosstab report from any relational table using simple SQL, and store any data from a crosstab table to a relational table. |
| PL/SQL 101 series -- 9 new(er) features of Oracle PL/SQL (13) |
| PL/SQL 101 series -- understanding and using PL/SQL for accessing Oracle Database (1-12) |
| Queries for Administration - Session (also for Structure, Performance, Backup, Miscellaneous, SQL*Net) |
| Regular Expressions |
| Returning Rows Through a Table Function in Oracle |
| Sending email from the database with the Utl_Smtp package |
| Speeding Up Queries with Semi-Joins and Anti-Joins: How Oracle Evaluates EXISTS, NOT EXISTS, IN, and NOT IN |
| SQL & PL/SQL QUESTIONS & ANSWERS (01) |
| SQL FAQ |
| SQL for Analysis and Reporting -- OracleŽ Database Data Warehousing Guide 10g Release 2 (10.2) |
| SQL for Web Nerds |
| SQL*Loader FAQ |
| SQL*Plus User's Guide and Reference Release 9.2 |
| Trees in Oracle SQL -- Family Tree, Organization Tree - CONNECT BY, LEVEL, PRIOR |
| Using Pipelined and Parallel Table Functions |
| Using the MERGE Statement |
| UTL_SMTP -- A PL/SQL code example to demonstrate how to use |
| UTL_SMTP -- A PL/SQL package to demonstrate how to use |
| What's New in PL/SQL? (11g) |
| XML Database Developers Guide - Oracle XML DB Release 2 (PDF) |
| XMLTABLE : Convert XML Data into Rows and Columns using SQL |