CREATE TABLE statement is used to create a table in a database. Tables are defined as combination of rows and columns. And each table should have a name.

Syntax :

REATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
column_nameN data_type(size)
);

     The column_name specifies the names of the columns of the table. Here , column name is user defined . The data_type specifies what type of data the column can hold (e.g. varchar, number , date . . ) . These data types are predefined . The size parameter specifies the maximum length of the column of the table . Remember , SQL Queries are case insensitive .

Example :

create table STUDENT
  (
    STUDENT_ID     number(10) ,
    STUDENT_NAME   varchar(100) ,
    STUDENT_MOB_NO varchar(13) ,
    STUDENT_ADREES varchar2(200)
  );
  
The Student_Id will hold the number upto 10 digits . Student_Name , Student_Mob_No and Student_Address will hold upto 100 , 13 and 200 characters respectively .