Bonus and Salgrade tables script in Oracle

Bonus and Salgrade tables script in Oracle, askhareesh blog for Oracle Apps
Bonus:
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