Oracle PLSQL Create Table

Create Table:

                           The Create table statement is used to create a new table in a database.

Syntax for Create Table:

                           CREATE TABLE Table_name ( Column1 data type (), Column2 data type(),…. );

 The data type Parameters specifies the type of data the column can hold (e.g varchar, number, integer etc).

Example for Create Table:

                            In this example we create table called emp that contains four columns: ename,  eid, DOJ, esal: 

                          CREATE TABLE EMP1 ( ename varchar2 (20), eid number(6), DOJ date(), esal number(6));