Bonus:
Salgrade:
Salgrade Table data:
Also read: EMP and DEPT tables script in Oracle
create table bonus( ename varchar2(10), job varchar2(9), sal number, comm number);
Salgrade:
create table salgrade( grade number, losal number, hisal number );
Salgrade Table data:
insert into salgrade values (1, 700, 1200); insert into salgrade values (2, 1201, 1400); insert into salgrade values (3, 1401, 2000); insert into salgrade values (4, 2001, 3000); insert into salgrade values (5, 3001, 9999);
Also read: EMP and DEPT tables script in Oracle
No comments:
Post a Comment