Oracle SQL Create Table

It is used to create Database Objects like tables, views, synonyms, indexes etc.

 

Syntax:

create table <table_name>

(col1 datatype1,

col2 datatype2 …

coln datatypen );

 

Create Employees Table

 

create table employees (

    employee_id    number(6, 0),

    first_name     varchar2(20 char),

    last_name      varchar2(25 char),

    email          varchar2(25 char),

    phone_number   varchar2(20 char),

    hire_date      date,

    job_id         varchar2(10 char),

    salary         number(8, 2),

    commission_pct number(2, 2),

    manager_id     number(6, 0),

    department_id  number(4, 0)

);

Create Emp Table

 

create table emp (

    empno    number(4, 0),

    ename    varchar2(10 byte),

    job      varchar2(9 byte),

    mgr      number(4, 0),

    hiredate date,

    sal      number(7, 2),

    comm     number(7, 2),

    deptno   number(2, 0)

);

 

Desc Table;

 

Note: In oracle, in a table, Max we can maintain 1000 columns.