Lecture Progress:

Create Table (3:38 min)

The lecture covers the create table syntax, including columns and data types. Table constraints are covered in separate lectures. The length of Table name and Column name  should not exceed 30 alphanumeric characters and has to start with a letter.

Quick Reference:

CREATE Table Syntax:

CREATE TABLE table_name (

column_name1 datatype (size),

column_name2 datatype(size),

…);

Example:

CREATE TABLE HR_Employees (

                                              Employee_id Number,

                                              Full_name Varchar2(100),

                                              Salary Number (10,2),

                                              Hire_Date Date,

                                              Email Varchar(30),

                                              Job_id varchar2(10),                       

                                              Commission_pct number(2,2),

                                              Manager_id Number,

                                              Department_id Number(4)

                                                );