Friday, June 25, 2010

Create table In Oracle

Table Creation Simple Example

CREATE TABLE Syntax:
CREATE TABLE TABLENAME (
   field1 data_type,
   field2 data_type,
   ...
   ...
   fieldn data_type
)

here,
Consider
Two Fields;
1) E_ID as number
2) E_Name as varchar(20)

CREATE TABLE Example
CREATE TABLE EMPLOYEE
   (
   E_ID NUMBER,
   E_NAME VARCHAR2(20)
   );

No comments: