Oracle DDL

• Oracle Data Types
• Creating a table
• Creating indexes
• Creating constraints
• Creating sequences
• Creating triggers
• Renaming a table
• Synonyms and database links
• Changing a column's type or name
• Moving a table
• Partitioned Tables

Oracle PL-SQL

• Using SQL-Plus
• Creating a stored procedure
• Displaying output
• Output variables
• Arrays and structures
• Conditionals
• Looping
• Cursors
• Packages
• Exception handling
• Using blobs
• Using the Context cartridge
• Sleep and wait
• Date Manipulation
• Complex IF/THEN Example

Back to top page