HierarchyData

View All Public Scripts Login to Run Script

Statement 4

create table hdr ( a int, b varchar2(30), c varchar2(30) )

Table created.

Statement 5

create table line (a int, b int, c varchar2(30), d varchar2(30))

Table created.

Statement 6

create table dtl (a int, b int, c int, d varchar2(30), e varchar2(30))

Table created.

Statement 7

insert into hdr values (1, 'HEADER1', 'HEADER2')

1 row(s) inserted.

Statement 8

insert into line values (1, 1, 'LINE11', 'LINE12')

1 row(s) inserted.

Statement 9

insert into line values (1, 2, 'LINE21', 'LINE22')

1 row(s) inserted.

Statement 10

insert into dtl values (1, 1, 1, 'DTL111', 'DTL112')

1 row(s) inserted.

Statement 11

insert into dtl values (1, 1, 2, 'DTL211', 'DTL212')

1 row(s) inserted.

Statement 12

insert into dtl values (1, 2, 1, 'DTL121', 'DTL122')

1 row(s) inserted.

Statement 13

insert into dtl values (1, 2, 2, 'DTL221', 'DTL222')

1 row(s) inserted.

Statement 17

create table hdr ( a int, b varchar2(30), c varchar2(30) )

Table created.

Statement 18

create table line (a int, b int, c varchar2(30), d varchar2(30))

Table created.

Statement 19

create table dtl (a int, b int, c int, d varchar2(30), e varchar2(30))

Table created.

Statement 20

insert into hdr values (1, 'HEADER1', 'HEADER2')

1 row(s) inserted.

Statement 21

insert into line values (1, 1, 'LINE11', 'LINE12')

1 row(s) inserted.

Statement 22

insert into line values (1, 2, 'LINE21', 'LINE22')

1 row(s) inserted.

Statement 23

insert into dtl values (1, 1, 1, 'DTL111', 'DTL112')

1 row(s) inserted.

Statement 24

insert into dtl values (1, 1, 2, 'DTL211', 'DTL212')

1 row(s) inserted.

Statement 25

insert into dtl values (1, 2, 1, 'DTL121', 'DTL122')

1 row(s) inserted.

Statement 26

insert into dtl values (1, 2, 2, 'DTL221', 'DTL222')

1 row(s) inserted.

A	B	C
1	HEADER1	HEADER2

Statement 28

select * from line


A B C D
1 1 LINE11 LINE12
1 2 LINE21 LINE22

2 rows selected.

A	B	C	D
1	1	LINE11	LINE12
1	2	LINE21	LINE22

Statement 29

select * from dtl


A B C D E
1 1 1 DTL111 DTL112
1 1 2 DTL211 DTL212
1 2 1 DTL121 DTL122
1 2 2 DTL221 DTL222

4 rows selected.

Additional Information