Session 01

View All Public Scripts Login to Run Script

Script Name Session 01
Visibility Unlisted - anyone with the share link can access
Description ORA_BUG
Area SQL General
Contributor ora_job@web.de
Created Wednesday November 30, 2016

Statement 1

CREATE TABLE suh_tb_test
(
    tb_id    NUMBER
)

Table created.

Statement 2

INSERT INTO suh_tb_test
VALUES (1)

1 row(s) inserted.

Statement 3

INSERT INTO suh_tb_test
VALUES (2)

1 row(s) inserted.

Statement 4

INSERT INTO suh_tb_test
VALUES (3)

1 row(s) inserted.

Statement 5
```
COMMIT
```
```
Statement processed.
```

Statement 6

CREATE TABLE suh_tb_test_1
(
    tb_1_id    NUMBER
)

Table created.

Statement 7

SELECT 	a.tb_id
FROM 	suh_tb_test a
WHERE	a.tb_id NOT IN 	(
						SELECT 	tb_id			--	tb_id does not exist in suh_tb_test_1!!
						FROM 	suh_tb_test_1
						)


TB_ID
1
2
3

3 rows selected.

TB_ID
1
2
3

Statement 8

SELECT 	a.tb_id
FROM 	suh_tb_test a
WHERE	NOT EXISTS 	(
					SELECT 	tb_id				--	tb_id does not exist in suh_tb_test_1!!
					FROM 	suh_tb_test_1
					)


TB_ID
1
2
3

3 rows selected.

TB_ID
1
2
3

Statement 9

INSERT INTO suh_tb_test_1
VALUES (1)

1 row(s) inserted.

Statement 10

INSERT INTO suh_tb_test_1
VALUES (2)

1 row(s) inserted.

Statement 11
```
COMMIT
```
```
Statement processed.
```

Statement 12

SELECT 	a.tb_id
FROM 	suh_tb_test a
WHERE	a.tb_id NOT IN 	(
						SELECT 	tb_id			--	tb_id does not exist in suh_tb_test_1!!
						FROM 	suh_tb_test_1
						)

no data found

Statement 13

SELECT 	a.tb_id
FROM 	suh_tb_test a
WHERE	NOT EXISTS 	(
					SELECT 	tb_id				--	tb_id does not exist in suh_tb_test_1!!
					FROM 	suh_tb_test_1
					)

no data found

Additional Information

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