Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

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;
21 rows affected

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;
34 rows affected

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


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

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

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