In this module, you learned to:
Create a table
Work with the basic Oracle datatypes
Create a table using the Schema Manager
Generate a list of the tables in your Oracle database
Gather information about the columns in a table
Modify a table by adding or modifying columns
Delete a table
In this module, you learned the following glossary terms:
- CASE: Computer Aided Software Design, a process where the implementation details of application systems are partially determined through computerized automation.
- Data Definition Language: The portion of the SQL language that is used to create and alter the structures that hold the data in the database.
- Data Dictionary: A group of tables and views that define the structures in a database.
- National Language Subset: A group of characters that are used to represent a specific national language or dialect.
- Oracle interMedia: An option for the Oracle database designed for handling specific types of large data (such as images or spatial data) and text.
- Schema: A structure in an Oracle database that contains database structures, typically owned by the schema owner.
The next module is about the various ways you can add constraints to tables and columns that limit the values of data that can be placed into the database.
Click the Quiz link below to answer a few questions about altering and dropping tables.
Altering Dropping Tables - Quiz