Multitable insert with sequences

View All Scripts Login to Run Script

Script Name Multitable insert with sequences
Description Multitable insert with sequences
Area SQL General
Contributor ad
Created Friday February 23, 2018

Statement 1

CREATE TABLE T1 ( 
 ID NUMBER 
)

Table created.

Statement 2

CREATE TABLE T2 ( 
 ID NUMBER, 
 T1_ID NUMBER 
)

Table created.

Statement 3

CREATE SEQUENCE seq_t1

Sequence created.

Statement 4

CREATE SEQUENCE seq_t2

Sequence created.

Statement 5

INSERT ALL  
  INTO T1 ( ID ) VALUES ( seq_t1.nextval )  
  INTO T2 ( ID, T1_ID ) VALUES ( seq_t2.nextval, seq_t1.nextval)  
SELECT *   
FROM DUAL  
CONNECT BY LEVEL <= 10

20 row(s) inserted.

Statement 6

SELECT * FROM T1


ID
1
2
3
4
5
6
7
8
9
10

10 rows selected.

ID
1
2
3
4
5
6
7
8
9
10

Statement 7

SELECT * FROM T2


ID T1_ID
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10

10 rows selected.

Statement 8
```
DROP TABLE T1 
```
```
Table dropped.
```
Statement 9
```
DROP TABLE T2 
```
```
Table dropped.
```
Statement 10
```
DROP SEQUENCE seq_t1 
```
```
Sequence dropped.
```
Statement 11
```
DROP SEQUENCE seq_t2 
```
```
Sequence dropped.
```

ID	T1_ID
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database