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