Oracle table creation example

Table creation example

create table Employee (

id number(4),

name varchar2(50)

);

Table created

describe Employee

Name    Null?    Type

——–     ——-   ——–

ID                       NUMBER(4)

Name                VARCHAR2(50)

insert into Employee values(100,’John’);

1 row created

select * from Employee;

ID  Name

 —  ——-

100  John