create table data_header(app_id number,label varchar2(400),seq number)

INSERT ALL INTO DATA_HEADER VALUES(1,'Title',1) INTO DATA_HEADER VALUES(1,'Group',2) INTO DATA_HEADER VALUES(1,'Aspect',3) INTO DATA_HEADER VALUES(1,'EPT',4) INTO DATA_HEADER VALUES(1,'IT',5) INTO DATA_HEADER VALUES(1,'BU',6) INTO DATA_HEADER VALUES(1,'Section',7) INTO DATA_HEADER VALUES(1,'Class',8) INTO DATA_HEADER VALUES(1,'Label Value Options',9) INTO DATA_HEADER VALUES(1,'Comments',10) INTO DATA_HEADER VALUES(2,'Title',1) INTO DATA_HEADER VALUES(2,'Group',2) INTO DATA_HEADER VALUES(2,'Aspect',3) INTO DATA_HEADER VALUES(2,'EPT',4) INTO DATA_HEADER VALUES(2,'IT',5) INTO DATA_HEADER VALUES(2,'BU',6) INTO DATA_HEADER VALUES(2,'Section',7) INTO DATA_HEADER VALUES(2,'Class',8) INTO DATA_HEADER VALUES(2,'Label Value Options',9) INTO DATA_HEADER VALUES(2,'Comments',10) INTO DATA_HEADER VALUES(2,'Remarks',11) select * from dual;

create table data_value(pid number,value varchar2(4000),app_id number,seq number)

INSERT ALL INTO DATA_VALUE VALUES(120,'Robert',1,1) INTO DATA_VALUE VALUES(120,'Deputy',1,2) INTO DATA_VALUE VALUES(120,'IT',1,3) INTO DATA_VALUE VALUES(120,'Synopsis is good',1,4) INTO DATA_VALUE VALUES(120,'Standard',1,5) INTO DATA_VALUE VALUES(120,'Code',1,6) INTO DATA_VALUE VALUES(120,'Green',1,7) INTO DATA_VALUE VALUES(120,'Needs Improvement for the details ',1,8) INTO DATA_VALUE VALUES(120,'Robert',2,1) INTO DATA_VALUE VALUES(120,'Deputy',2,2) INTO DATA_VALUE VALUES(120,'IT',2,3) INTO DATA_VALUE VALUES(120,'Synopsis is good',2,4) INTO DATA_VALUE VALUES(120,'Standard',2,5) INTO DATA_VALUE VALUES(120,'Code',2,6) INTO DATA_VALUE VALUES(120,'Green',2,7) INTO DATA_VALUE VALUES(120,'Needs Improvement for the details ',2,8) INTO DATA_VALUE VALUES(121,'Stanley',1,1) INTO DATA_VALUE VALUES(121,'Deputy',1,2) INTO DATA_VALUE VALUES(121,'IT',1,3) INTO DATA_VALUE VALUES(121,'Synopsis is good',1,4) INTO DATA_VALUE VALUES(121,'Standard',1,5) INTO DATA_VALUE VALUES(121,'Code',1,6) INTO DATA_VALUE VALUES(121,'Green',1,7) INTO DATA_VALUE VALUES(121,'Needs Improvement for the details ',1,8) INTO DATA_VALUE VALUES(121,'Average',1,9) INTO DATA_VALUE VALUES(121,'Stanley',2,1) INTO DATA_VALUE VALUES(121,'Deputy',2,2) INTO DATA_VALUE VALUES(121,'IT',2,3) INTO DATA_VALUE VALUES(121,'Synopsis is good',2,4) INTO DATA_VALUE VALUES(121,'Standard',2,5) INTO DATA_VALUE VALUES(121,'Code',2,6) INTO DATA_VALUE VALUES(121,'Green',2,7) INTO DATA_VALUE VALUES(121,'Needs Improvement for the details ',2,8) INTO DATA_VALUE VALUES(121,'Average',2,9) SELECT * FROM DUAL;

select * from data_header;

select * from data_value;