In Oracle, CREATE TABLE statement is used To create a new table in the Oracle database,
we have to use CREATE TABLE statement where we need a table name and define its columns and datatype for each column.
Syntax:
CREATE TABLE table_name (
column_1 data_type column_constraint,
column_2 data_type column_constraint,
...
table_constraint
);
In this syntax:
- First, specify the table name and schema name to which the new table belongs on the CREATE TABLE clause.
- Second, list all columns of the table within the parentheses. In case a table has multiple columns, you need to separate them by commas (,). A column definition includes the column name followed by its data type e.g., NUMBER, VARCHAR2, and a column constraint such as NOT NULL, primary key, check.
- Third, add table constraints if applicable e.g., primary key, foreign key, check.
