Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.
Oracle Database 12c R2 SQL: Data Definition Language (DDL)
- provide an overview of DLL, and describe the DDL database objects and the associated naming rules
- use the CREATE TABLE SQL command to create new tables in the database
- identify the different Oracle database data types used when creating a table
- define a default value to be assigned to a column when creating a table
- identify the different types of constraints and how these are used to enforce rules at a table level
- define constraints such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK
- create a new table and insert rows by combining CREATE TABLE and AS in a SQL statement
- change the definition of a table using the ALTER TABLE SQL command
- mark columns as unused with the SET UNUSED statement
- remove unused columns
- use the DROP TABLE SQL command to delete a table from the database
- create and work with tables using DDL
If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.