Title: Create a table.
Course: Database Design and Management (Oracle) (10052) > Section: Modifying and Managing Tables

Creation should include following these steps:

- Type the keyword CREATE TABLE [tablename]. Note that the table name cannot be more than 30 characters, start with anything but a letter; the keyword cannot be an SQL keyword and cannot contain any special characters except for the “$” and “_”.
- Choose the column names and the datatype and length necessary for each column (see the syntax example below).

CREATE TABLE employees(
employee_id NUMBER(6),
last_name VARCHAR2(25),
email VARCHAR2(25),
salary NUMBER(8,2),
commission_pct NUMBER(2,2),
hire_date DATE,
department_id NUMBER(4),

- Add other constraints as demanded by the table instance charts to ensure data integrity. Note that examples of constrains are NOT NULL, PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, and CHECK CONSTRAINT. Constraints may be added in the column definitions (called column-level constraints) or after the columns are defined (called table-level). NOT NULL constraints are a type of check constraint and can only be defined at column level. Constraints are needed in order to ensure data integrity.