Oracle CREATE TABLE
In Oracle, CREATE TABLE statement is used to create a new table in the database.
To create a table, you have to name that table and define its columns and datatype for each column.
Parameters used in syntax
Oracle CREATE TABLE Example
Here we are creating a table named customers. This table doesn't have any primary key.
This table contains three columns
Oracle CREATE TABLE Example with primary key
What is Primary key
A primary key is a single field or combination of fields that contains a unique record. It must be filled. None of the field of primary key can contain a null value. A table can have only one primary key.
In Oracle, total number of columns cannot be more than 32.