Wednesday, 20 July 2011

Table Create & Data insert

create table deptincrease
(
    deptno number,
    percentage number,
    primary key(deptno)
)

insert into deptincrease values(1,10);
insert into deptincrease values(2,12);
insert into deptincrease values(3,10);
insert into deptincrease values(4,5);
insert into deptincrease values(5,20);

No comments:

Post a Comment