|
This course examines creating and changing tables and defining constraints on tables in Oracle9i SQL.
Objectives:
After completing this course, students will be able to:
- Create, modify, rebuild, and remove tables
- Use the TRUNCATE command
- Create, modify and drop constraints
- Use primary key constraints
- Use foreign key contraints
- Add comments to SQL scripts and schema objects
Topics:
- Creating tables
- Relational and temporary tables
- Adding comments
- Changing table structures
- Renaming, truncating and dropping tables
- Constraints
- Primary key, unique and foreign key constraints
- Table level and check constraints
- Adding, modifying and dropping constraints
|
