Monday 22 February 2016

HOW TO CREATE A TABLE USING DBMS ?

create table tablename
(
coloumn1 datatype(size),
coloumn2 datatype(size),
.
.
.
coloumn10 datatype(size)
);

for example TO CREATE A TABLE EMPLOYEE_732

create table employee_668
(
e_name char(10),
e_id varchar(5),
e_salary number(6),
e_commission varchar(5)
);

No comments:

Post a Comment