Oracle SQL (19c)
Last updated: July, 2025 (Work in progress ...)
  1. Tables
    1. Standard Tables (Heap-Organized)
    2. Index-Organized Tables (IOT)
    3. Global Temporary Tables (GTT)
  2. Column Management
    1. Working with Columns
  3. Integrity Constraints
    1. Constraint Management
    2. NOT NULL Constraints
    3. CHECK Constraints
    4. UNIQUE Constraints
    5. PRIMARY KEY Constraints
    6. FOREIGN KEY Constraints
  4. SQL Operations
    1. SELECT Statements
      1. ORDER BY Clause and Row Limiting
      2. Hierarchical Queries (CONNECT BY)
      3. JOIN Operations
      4. Handling NULL Values in Oracle SQL
    2. INSERT Statements
    3. UPDATE Statements
    4. DELETE Statements
    5. MERGE Statements
  5. Index Management
    1. Working with Indexes
    2. Function-Based Indexes
      1. NVL Function Indexes
      2. NLSSORT Function Indexes
  6. National Language Support (NLS)
    1. Oracle National Language Support Overview
    2. NLS_SORT Parameter
    3. NLS_COMP Parameter
  7. Query Execution Plans
    1. Estimated Execution Plans
    2. Actual Execution Plans
    3. Table Access Methods
    4. SQL Join Methods
Appendix
  1. SQL JOIN Reference Guide
  2. Oracle Database Recycle Bin
References

Books

Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions

Authors: Thomas Kyte
Publisher: Apress; 2 Edition (July 2010)
ISBN: 978-1430229469

Pro Oracle SQL (Expert's Voice in Oracle)

Authors: Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Still
Publisher: Apress (December 2010)
ISBN: 978-1430232285

Documentation & Resources

Oracle® Database Reference - 19c

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/index.html

Oracle® Database Globalization Support Guide - 19c

https://docs.oracle.com/en/database/oracle/oracle-database/19/nlspg/index.html

Oracle® Text Application Developer's Guide - 19c

https://docs.oracle.com/en/database/oracle/oracle-database/19/ccapp/index.html
© 2025