Saturday, 7 September 2013

Basic information about Database Table

Introduction about table:

Table is database object in oracle which stores the data in organized manner.

Table contains mainly

  • Table Name.
  • Column Name.
  • Data Type. 

Syntax:

Create table tablename(columnname1 datatype,columnname2 datatype,..........columnname1000 datatype);

Example:

Create table Emp(Ename varchar2(50),Eid varchar2(10),Esal number);

No comments:

Post a Comment