Computing Science 291 / 391

Laboratory Manual

by

Instructional Support Group

(September 1995)

---

Table of Contents

1. Intro to ORACLE
   
   
2. ORACLE Architecture and Terminology
   • Memory Structures and Processes
     • Memory Structures
     • Processes
   • Database Structures
     • Logical Database Structure
     • Physical Database Structure
   
   
   
3. Starting ORACLE and Setting Environment Variables
   • Starting ORACLE
   • Setting Up Your Preferred Editor
   • Online Error Messages
   • An Introduction to the Data Dictionary
   • Reporting Problems
   
   
   
4. SQL*Plus (NOTE: old manual for SQL*Plus and SQL*Loader )
   • Starting SQL*Plus
   • Leaving SQL*Plus
   • Entering and Executing Commands
   • SQL Commands
   • SQL*Plus Commands
   • Interactive SQL*Plus Commands
   • Formatting Query Results
   • Defining Page Titles and Dimensions
   
   
   
5. SQL*Loader
   • Control File Syntax
     • Comments
     • The OPTIONS Clause
   • Continuing Interrupted Loads
   • Identifying Data Files
   • Loading into Non-Empty Database Tables
   • Loading Logical Records into Tables
   • Specifying Datatypes
     • Native Datatypes
     • Character Datatypes



6. SQL Language Reference
   • Schema Objects
   • Object Naming Rules
   • Referring to Objects and Parts
   • Datatypes
     • Character Datatypes
     • Number Datatypes
     • Long Datatypes
     • Date Datatype
     • Raw and Long Raw Datatype
     • RawID Datatype
   • Data Conversion
   • Nulls
   • Comments
   • Operators
   • Functions
     • Single Row Functions
     • Group Functions
   • Format Models
     • Number Format Models
     • Date Format Models
   • Data Definition Language (DDL) SQL Commands
     • CREATE SCHEMA
     • CREATE TABLE
     • CREATE VIEW
     • GRANT
     • CREATE INDEX
     • CREATE ROLE
     • CREATE SEQUENCE
     • CREATE SYNONYM
     • ALTER TABLE
     • DROP TABLE
     • TRUNCATE
     • CONSTRAINT clause
   
   
   
7. Oracle Reports 2.0
8. Form Lab 1
9. Form Lab 2
10. Form Lab 3
    
    
11. SQL MENU
    • Overview of Menu Design
    • Starting and Quitting SQL*Menu (Design)
    • Getting Help Information
    • Object Hierarchy
    • Object-Naming Conventions
    • Applications
    • Menus
    • Menus Items
    • SQL*Menu Command Types
      • Type 1: Invoking a Submenu
      • Type 2 and 3: Executing Operating System Commands
      • Type 4: Invoking SQL*Forms
      • Type 5: Invoking SQL*Plus
      • Type 6: Executing Macro Commands
      • Type 7: Executing PL/SQL Commands
    • Substitution Parameters
    • Procedures
    • Packaged Procedure Overview
    
    
    
12. PL/SQL
    • Overview of PL/SQL
    • Fundamentals of PL/SQL
      • Lexical Units
      • Datatypes
      • Datatype Conversion
      • Declarations
      • Naming Conventions
      • Scope and Visibility
      • Assignments
      • Expressions and Comparisons
      • Built-in Functions
      • PL/SQL Tables
      • User-defined Records
    • Control Structures
      • Conditional Control: IF Statements
      • Iterative Control: LOOP and EXIT Statements
      • Sequential Control: GOTO and NULL Statements
    • Interaction With ORACLE
      • SQL Support
    • Cursor Management
      • Packaged Cursors
      • Cursor FOR Loops
      • Overriding Default Locking
      • Database Triggers
    • Error Handling
      • Overview
      • Advantages of Exceptions
      • Predefined Exceptions
      • User-defined Exceptions
      • How Exceptions Are Raised
      • Handling Raised Exceptions
    • Subprograms
      • Procedures
      • Functions
      • RETURN Statement
      • Forward Declarations
      • Actual Versus Formal Parmeters
      • Parameter Modes
      • Overloading
      • Stored Subprograms
    • Packages
      • The Package Specification
      • The Package Body
      • Guidelines
    
    
    
13. Appendix
    • Appendix A - Reserved Words
    • Appendix B - Keywords
    • Appendix C - Control File Syntax