1. 7.16.1. INTRODUCTION
  2. 7.16.2. USING ORACLE
    1. 7.16.2.1. ORACLE
    2. 7.16.2.2. STARTING ORACLE
      1. 7.16.2.2.1. SETTING UP YOUR ACCOUNT
    3. 7.16.2.3. THE ORACLE HIERARCHY
  3. 7.16.3. CREATING AND MAINTAINING TABLES
    1. 7.16.3.1. ISSUING SQL COMMANDS
    2. 7.16.3.2. CREATING TABLES
      1. 7.16.3.2.1. THE PRIMARY KEY
      2. 7.16.3.2.2. MANDATORY COLUMNS
    3. 7.16.3.3. DESCRIBING A TABLE
    4. 7.16.3.4. PLACING DATA INTO TABLES
    5. 7.16.3.5. UPDATING INFORMATION
    6. 7.16.3.6. DELETING INFORMATION
      1. 7.16.3.6.1. DELETING A TABLE
    7. 7.16.3.7. ALTERING A TABLE
    8. 7.16.3.8. ROLLBACK AND COMMIT
  4. 7.16.4. RETRIEVING INFORMATION
    1. 7.16.4.1. SELECTING INFORMATION
    2. 7.16.4.2. JOINING TABLES
  5. 7.16.5. WRITING REPORTS
    1. 7.16.5.1. ORACLE SETTINGS
    2. 7.16.5.2. COLUMN FORMATTING
    3. 7.16.5.2.1. THE FORMAT SPECIFIER
    4. 7.16.5.3. BREAK LOGIC
  6. 7.16.6. PROGRAMMING WITH PL/SQL
    1. 7.16.6.1. CHARACTER SET
    2. 7.16.6.2. PROGRAMMING CONSTRUCTS
      1. 7.16.6.2.1. EXECUTING PL/SQL PROCEDURES
    3. 7.16.6.3. DECLARING VARIABLES
    4. 7.16.6.4. EXCEPTIONS
    5. 7.16.6.5. if LOGIC STRUCTURES
      1. 7.16.6.5.1. if-then
      2. 7.16.6.5.2. if-then-else
      3. 7.16.6.5.3. if-then-elsif
    6. 7.16.6.6. DO NOTHING
    7. 7.16.6.7. LOOPS
      1. 7.16.6.7.1. loop-exit-end
      2. 7.16.6.7.2. loop-exit when-end
      3. 7.16.6.7.3. while-loop-end
      4. 7.16.6.7.4. for-in-loop-end
    8. 7.16.6.8. CURSORS
      1. 7.16.6.8.1. EXPLICIT CURSORS
      2. 7.16.6.8.2. IMPLICIT CURSORS
  7. 7.16.7. EMBEDDED SQL
    1. 7.16.7.1. DEVELOPING AN EMBEDDED SQL PROGRAM
    2. 7.16.7.2. CODING EMBEDDED SQL STATEMENTS
    3. 7.16.7.3. THE SQL COMMUNICATIONS AREA
      1. 7.16.7.3.1. SQLCODE AND SQLSTATE
    4. 7.16.7.4. COPING WITH ERRORS
    5. 7.16.7.5. DATATYPE CONVERSION
    6. 7.16.7.6. CONNECTING TO YOUR DATABASE
    7. 7.16.7.7. ISSUING A COMMAND TO THE DATABASE
    8. 7.16.7.8. MULTI-ROW QUERIES
    9. 7.16.7.9. A COMPLETE EXAMPLE
    10. 7.16.7.10. COMPILING AND RUNNING RE-VISITED
  8. 7.16.8. OTHER SOURCES OF DOCUMENTATION