SQL> create table payslip(empcode varchar2(4) primary key, basic number(6) not null,
2 hra number(6) not null, da number(6) not null, foreign key(empcode) references
3 emply(empcode));
Table created.
SQL> insert into payslip values('&empcode', &basic, &hra, &da);
Enter value for empcode: E101
Enter value for basic: 4000
Enter value for hra: 1900
Enter value for da: 1500
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E101', 4000, 1900, 1500)
1 row created.
SQL> /
Enter value for empcode: E102
Enter value for basic: 4500
Enter value for hra: 2200
Enter value for da: 2000
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E102', 4500, 2200, 2000)
1 row created.
SQL> /
Enter value for empcode: E103
Enter value for basic: 5000
Enter value for hra: 2800
Enter value for da: 2200
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E103', 5000, 2800, 2200)
1 row created.
SQL> /
Enter value for empcode: E104
Enter value for basic: 7000
Enter value for hra: 3000
Enter value for da: 2700
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E104', 7000, 3000, 2700)
1 row created.
SQL> /
Enter value for empcode: E105
Enter value for basic: 3000
Enter value for hra: 1500
Enter value for da: 1200
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E105', 3000, 1500, 1200)
1 row created.
SQL> /
Enter value for empcode: E106
Enter value for basic: 5700
Enter value for hra: 3000
Enter value for da: 2900
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E106', 5700, 3000, 2900)
1 row created.
SQL> /
Enter value for empcode: E107
Enter value for basic: 6200
Enter value for hra: 3300
Enter value for da: 3000
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E107', 6200, 3300, 3000)
1 row created.
SQL> /
Enter value for empcode: E108
Enter value for basic: 5700
Enter value for hra: 3700
Enter value for da: 3000
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E108', 5700, 3700, 3000)
1 row created.
SQL> /
Enter value for empcode: E109
Enter value for basic: 7500
Enter value for hra: 4660
Enter value for da: 545
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E109', 7500, 4660, 545)
1 row created.
SQL> /
Enter value for empcode: E110
Enter value for basic: 5000
Enter value for hra: 300
Enter value for da: 100
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E110', 5000, 300, 100)
1 row created.
SQL> /
Enter value for empcode: E111
Enter value for basic: 6000
Enter value for hra: 200
Enter value for da: 120
old 1: insert into payslip values('&empcode', &basic, &hra, &da)
new 1: insert into payslip values('E111', 6000, 200, 120)
1 row created.
SQL> select * from payslip;
EMPC BASIC HRA DA
---- ---------- ---------- ----------
E101 4000 1900 1500
E102 4500 2200 2000
E103 5000 2800 2200
E104 7000 3000 2700
E105 3000 1500 1200
E106 5700 3000 2900
E107 6200 3300 3000
E108 5700 3700 3000
E109 7500 4660 545
E110 5000 300 100
E111 6000 200 120
11 rows selected.
|
