clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1579574 fiddles created (21352 in the last week).

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


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;
21 rows affected
 hidden batch(es)


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


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;
34 rows affected
 hidden batch(es)


select * from data_header;
APP_ID LABEL SEQ
1 Title 1
1 Group 2
1 Aspect 3
1 EPT 4
1 IT 5
1 BU 6
1 Section 7
1 Class 8
1 Label Value Options 9
1 Comments 10
2 Title 1
2 Group 2
2 Aspect 3
2 EPT 4
2 IT 5
2 BU 6
2 Section 7
2 Class 8
2 Label Value Options 9
2 Comments 10
2 Remarks 11
 hidden batch(es)


select * from data_value;
PID VALUE APP_ID SEQ
120 Robert 1 1
120 Deputy 1 2
120 IT 1 3
120 Synopsis is good 1 4
120 Standard 1 5
120 Code 1 6
120 Green 1 7
120 Needs Improvement for the details 1 8
120 Robert 2 1
120 Deputy 2 2
120 IT 2 3
120 Synopsis is good 2 4
120 Standard 2 5
120 Code 2 6
120 Green 2 7
120 Needs Improvement for the details 2 8
121 Stanley 1 1
121 Deputy 1 2
121 IT 1 3
121 Synopsis is good 1 4
121 Standard 1 5
121 Code 1 6
121 Green 1 7
121 Needs Improvement for the details 1 8
121 Average 1 9
121 Stanley 2 1
121 Deputy 2 2
121 IT 2 3
121 Synopsis is good 2 4
121 Standard 2 5
121 Code 2 6
121 Green 2 7
121 Needs Improvement for the details 2 8
121 Average 2 9
 hidden batch(es)