Create table In Oracle Simple Example

Create table In Oracle

The Data Definition Language (DDL) manages table and index structure. The most basic items of DDL are the CREATE, ALTER, RENAME, DROP and TRUNCATE statements. Here we see about Create Table with examples

Create Table Statement

A CREATE TABLE statement creates a table. Tables contain columns and constraints, rules to which data must conform. Table-level constraints specify a column or columns. Columns have a data type and can specify column constraints (column-level constraints).

Create table In Oracle Syntax:

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

Create table In Simple Example Declaration:

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

Create table In Oracle Simple Example Code:

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