| Bookmarks |
| 1 |
*** Interview Questions *** |
|
| 2 |
*** Mastering Oracle PL/SQL: Practical Solutions *** |
|
| 3 |
Advanced PL/SQL (Oracle DB 10g) (PDF) |
|
| 4 |
Analytic functions by Example -- LEAD, LAG, RANK, DENSE_RANK, FIRST... |
|
| 5 |
Analytic functions by Example -- LEAD, LAG, RANK, DENSE_RANK, FIRST... (PDF) |
|
| 6 |
Application and Networking Architecture |
|
| 7 |
Convert XML data into rows and columns using SQL |
|
| 8 |
Database Administration |
|
| 9 |
Database Specialists - Tutorials and White Papers |
|
| 10 |
DBMS_JOB |
|
| 11 |
DBMS_SCHEDULER |
|
| 12 |
Email From PL/SQL In Oracle9i |
|
| 13 |
Handling PL/SQL Errors -- PL/SQL User's Guide and Reference |
|
| 14 |
How to Convert Rows to Columns and Back Again with SQL (Aka PIVOT and UNPIVOT) |
|
| 15 |
How to Extract xmltype as xml in Oracle |
|
| 16 |
LISTAGG function |
|
| 17 |
LISTAGG function in 11g release 2 - a built-in function that enables us to perform string aggregation natively |
|
| 18 |
Oracle and XML In Action - A Real World Example |
|
| 19 |
Oracle Applications Developer's Guide (PDF) |
|
| 20 |
Oracle Bitmap Index Techniques |
|
| 21 |
Oracle Built-In Functions |
|
| 22 |
Oracle Connect By Function |
|
| 23 |
Oracle Database -- 2 Day DBA |
|
| 24 |
Oracle Database Error Code Explained |
|
| 25 |
Oracle Database Installing and Upgrading |
|
| 26 |
Oracle Database List of Books -- 10g Release 1 (10.1) |
|
| 27 |
Oracle Database List of Books -- 11g Release 2 (11.2) |
|
| 28 |
Oracle Database List of Books -- 9i Release 2 (9.2) |
|
| 29 |
Oracle Database Master Glossary 11g Release 2 (11.2) |
|
| 30 |
ORACLE FAQ'S |
|
| 31 |
Oracle Glossary |
|
| 32 |
Oracle Interview Questions |
|
| 33 |
Oracle PIPE ROW statement |
|
| 34 |
Oracle PIPELINED Table Functions -- Akadia |
|
| 35 |
Oracle Pipelined Table Functions -- Oracle-Base |
|
| 36 |
Oracle Programming with PL/SQL Collections |
|
| 37 |
Oracle Row Generator Techniques |
|
| 38 |
Oracle WITH Clause |
|
| 39 |
OracleŽ Database Concepts 11g Release 2 (11.2) |
|
| 40 |
OracleŽ Database Performance Tuning Guide |
|
| 41 |
OracleŽ Database PL/SQL Collections and Records -- PL/SQL User's Guide and Reference - Release 2 (9.2) |
|
| 42 |
OracleŽ Database PL/SQL FAQ |
|
| 43 |
OracleŽ Database PL/SQL Language Reference 11g Release 2 (11.2) |
|
| 44 |
OracleŽ Database PL/SQL Optimization and Tuning |
|
| 45 |
OracleŽ Database PL/SQL User s Guide and Reference -- 10g Release 1 (PDF) |
|
| 46 |
OracleŽ Database PL/SQL User s Guide and Reference -- Release 2 (9.2) |
|
| 47 |
OracleŽ Database PL/SQL User's Guide and Reference
10g Release 2 (10.2)
|
|
| 48 |
OracleŽ Database SQL Language Reference -- 11g Release 2 (11.2) |
|
| 49 |
OracleŽ XML DB Developer's Guide - 10g Release 2 (10.2) |
|
| 50 |
OracleŽ XML DB Developer's Guide - Using XMLType |
|
| 51 |
Oracle-Base -- Collections |
|
| 52 |
Oradev.com - Portal for Oracle Developer |
|
| 53 |
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. |
|
| 54 |
PL/SQL 101 series -- 9 new(er) features of Oracle PL/SQL (13) |
|
| 55 |
PL/SQL 101 series -- understanding and using PL/SQL for accessing Oracle Database (1-12) |
|
| 56 |
Queries for Administration - Session (also for Structure, Performance, Backup, Miscellaneous, SQL*Net) |
|
| 57 |
Regular Expressions |
|
| 58 |
Returning Rows Through a Table Function in Oracle |
|
| 59 |
Sending email from the database with the Utl_Smtp package |
|
| 60 |
Speeding Up Queries with Semi-Joins and Anti-Joins: How Oracle Evaluates EXISTS, NOT EXISTS, IN, and NOT IN |
|
| 61 |
SQL & PL/SQL QUESTIONS & ANSWERS (01) |
|
| 62 |
SQL FAQ |
|
| 63 |
SQL for Analysis and Reporting -- OracleŽ Database Data Warehousing Guide 10g Release 2 (10.2) |
|
| 64 |
SQL for Web Nerds |
|
| 65 |
SQL*Loader FAQ |
|
| 66 |
SQL*Plus User's Guide and Reference Release 9.2 |
|
| 67 |
Trees in Oracle SQL -- Family Tree, Organization Tree - CONNECT BY, LEVEL, PRIOR |
|
| 68 |
Using Pipelined and Parallel Table Functions |
|
| 69 |
Using the MERGE Statement |
|
| 70 |
UTL_SMTP -- A PL/SQL code example to demonstrate how to use |
|
| 71 |
UTL_SMTP -- A PL/SQL package to demonstrate how to use |
|
| 72 |
What's New in PL/SQL? (11g) |
|
| 73 |
XML Database Developers Guide - Oracle XML DB Release 2 (PDF) |
|
| 74 |
XMLTABLE : Convert XML Data into Rows and Columns using SQL |
|