insert

--- filling job experience automatic by trigger
DROP TRIGGER TR_GRADE;
CREATE or REPLACE TRIGGER TR_GRADE
BEFORE UPDATE OR INSERT ON jobs
FOR EACH ROW
BEGIN
      IF EXTRACT(DAY FROM(systimestamp - :new.start_date)) > 1  THEN
        :new.experience := EXTRACT(DAY FROM(systimestamp - :new.start_date));
      else
      :new.experience := 0;
    END IF;
END TR_GRADE;
/
SHOW ERRORS;

--- INSERTIONS
insert into member values (01,'Bikash','Roy','Khalishpur,Khulna','bikash@gmail.com','www.bikash.com');
insert into member values (02,'Tusher','Pranto','Dhap,Rangpur','tusher@gmail.com','www.tusher.com');
insert into member values (03,'Hasib','Iqbal','Mirpur,Dhaka','hasib@gmail.com','www.hasib.com');
insert into member values (04,'Mahedi','Hasan','farmgate,Dhaka','mahedi@gmail.com','www.mahedi.com');
insert into member values (05,'Arnab','Majumder','Khalishpur,Khulna','arnab@gmail.com','www.arnab.com');


insert into company values (01,'Apple','Software','Bangladesh','apple@gmail.com','www.apple.org');
insert into company values (02,'Most Corp.','IT','India','most@gmail.com','www.most.org');
insert into company values (03,'Intel','Hardware','USA','intel@gmail.com','www.intel.org');
insert into company values (07,'Intel','Hardware','UK','intel@gmail.com','www.intel.org');
insert into company values (05,'Most Corp.','IT','India','most@gmail.com','www.most.org');
insert into company values (04,'IBM','Software','Canada','ibm@gmail.com','www.ibm.org');

insert into jobs values (01,01,'MD',40000,'Software','17-DEC-10','');
insert into jobs values (02,02,'Chairman',30000,'IT','25-AUG-10','');
insert into jobs values (03,03,'CEO',50000,'Hardware','09-JUN-13','');
insert into jobs values (04,04,'Manager',30000,'Data','09-JUN-13','');
insert into jobs values (05,05,'Manager',35000,'Software','09-JAN-13','');


---- insertion with transaction
insert into study values (01,'CSE','Android','12-APR-05','29-JAN-09');
savepoint sp1;
insert into study values (02,'CSE','AI','12-APR-05','29-JAN-09');
savepoint sp2;
insert into study values (03,'ECE','Machine Learning','12-APR-05','29-JAN-09');
savepoint sp3;
insert into study values (04,'EEE','networking','12-JUN-05','29-JAN-04');
savepoint sp4;
insert into study values (05,'CSE','IOS','12-APR-05','29-JAN-09');
savepoint sp5;
insert into study values (06,'EEE','networking','12-JUN-05','29-JAN-04');
savepoint sp6;
insert into study values (07,'EEE','IOS','18-APR-05','20-JAN-09');
savepoint sp7;

rollback to sp5;



select * from member;
select * from company;
select * from study;
select * from jobs;

commit;