• Home
  • LLMs
  • Docker
  • Kubernetes
  • Java
  • Ubuntu
  • Maven
  • Archived
  • About
Introduction à Oracle SQL
  1. SQL
    1. SELECT
      1. ORDER BY
      2. CONNECT BY
      3. JOIN
      4. NULL (Gestion de NULL avec Oracle SQL)
    2. INSERT
    3. UPDATE
    4. DELETE
    5. MERGE
  2. Tables
    1. TABLE (Heap Organized Tables)
    2. Index Organized Tables (IOT)
    3. Global Temporary Tables (GTT)
  3. Colonnes
    1. COLUMN
  4. Contraintes d'intégrité
    1. CONSTRAINT
    2. CHECK
    3. NOT NULL
    4. UNIQUE
    5. PRIMARY KEY
    6. FOREIGN KEY
  5. NLS
    1. NLS (Oracle's National Language Support)
    2. NLS_SORT (Oracle's National Language Support - SORT)
    3. NLS_COMP (Oracle's National Language Support - COMP)
  6. Indexes
    1. INDEX
    2. Function Based Indexes
      1. NVL
      2. NLSSORT
  7. Plan d'exécution
    1. Plan d'exécution estimatif
    2. Plan d'exécution réel
    3. Méthodes d'accès (access methods)
    4. Méthodes de jointure (join methods)
Annexes
  1. SQL JOIN Cheat Sheet
  2. Oracle Database Installation (18c Express Edition)
  3. Oracle SQL Developer (19.1)
  4. Corbeille (recycle bin)
References
  • Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions
    Author: Thomas Kyte
    Publisher: Apress; 2 Edition (July 2010)
    ISBN: 978-1430229469
  • Pro Oracle SQL (Expert's Voice in Oracle)
    Author: Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Still
    Publisher: Apress (December 2010)
    ISBN: 978-1430232285
  • Oracle® Database Reference - 18c
    https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/index.html
  • Oracle® Database Globalization Support Guide - 18c
    https://docs.oracle.com/en/database/oracle/oracle-database/18/nlspg/index.html
  • Oracle® Text Application Developer's Guide - 18c
    https://docs.oracle.com/en/database/oracle/oracle-database/18/ccapp/index.html
© 2025  mtitek