How to Create Table in Oracle

In this tutorial i'll show you many different type to manage and create the table.

1. Create Table 
2. Alter Table

 1. Create Table
      Table is basic storage unite of data, and oracle table can store data in row column format.     
      Using this statement you can create table in oracle.
      Before you create table you must have CREATE TABLE system privilege, and one more think
you he owner of the table must have a quota for the tablespace that contains the table, or the UNLIMITED TABLESPACE system privilege.

  Syntax :

 CREATE TABLE tbl_name
  (
   ColumnName1 Datatype [Constraint],
   ColumnName2 Datatype [Constraint],
   .
   .
   .
   ColumnNamen Datatype [Constraint]
  );

Parameter Name or Arguments :

• ColumnName  

                Here you are specify the name of the column it means it helps to identified the column data,
        you can't user the spacial character or constraint of the oracle or any schema name or same  
        name.

•  Datatype

                 In this you want use the oracle predefined data type, so you can store same type of data in
       column, like filter process.  

• Constraint 

                 If you want put a condition in you column on data at a time it's useful like,

                 CHECK, PRIMARY KEY, UNIQUE, NOT NULL, etc.

  Example :

Create Table

 That's are the exploration of Creating Table. 
And You can see Alter Table statement in my next tutorial.