Script_test_table

View All Public Scripts Login to Run Script

Script Name Script_test_table
Visibility Unlisted - anyone with the share link can access
Description Script_test_table
Area SQL General / SQL Query
Contributor aparna.pallath@gmail.com
Created Tuesday March 12, 2019

Statement 1

create table test_table (ord number,person_no number , flag number)

Table created.

Statement 2

insert into test_table values  (2999362,3754090,10)

1 row(s) inserted.

Statement 3

insert into  test_table values (2999362,3807718,8)

1 row(s) inserted.

Statement 4

insert into test_table values  (2999362,3991003,9)

1 row(s) inserted.

Statement 5

insert into  test_table values (2999362,5475332,7)

1 row(s) inserted.

Statement 6

insert into  test_table values (2999362,5475332,5)

1 row(s) inserted.

Statement 7

insert into  test_table values (2999362 ,10750089,4)

1 row(s) inserted.

Statement 8

insert into  test_table values (2999362, 11150508,6)

1 row(s) inserted.

Statement 9

insert into  test_table values (2999362, 12158176,3)

1 row(s) inserted.

Statement 10

insert into  test_table values (2999362, 21065699,1)

1 row(s) inserted.

Statement 11

insert into  test_table values (2999362, 21065699,2)

1 row(s) inserted.

Statement 12

create table test_table (ord number,person_no number , flag number)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 13

insert into test_table values  (2999362,3754090,10)

1 row(s) inserted.

Statement 14

insert into  test_table values (2999362,3807718,8)

1 row(s) inserted.

Statement 15

insert into test_table values  (2999362,3991003,9)

1 row(s) inserted.

Statement 16

insert into  test_table values (2999362,5475332,7)

1 row(s) inserted.

Statement 17

insert into  test_table values (2999362,5475332,5)

1 row(s) inserted.

Statement 18

insert into  test_table values (2999362 ,10750089,4)

1 row(s) inserted.

Statement 19

insert into  test_table values (2999362, 11150508,6)

1 row(s) inserted.

Statement 20

insert into  test_table values (2999362, 12158176,3)

1 row(s) inserted.

Statement 21

insert into  test_table values (2999362, 21065699,1)

1 row(s) inserted.

Statement 22

insert into  test_table values (2999362, 21065699,2)

1 row(s) inserted.

Statement 23
```
commit
```
```
Statement processed.
```

Statement 24

create table test_table (ord number,person_no number , flag number)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 25

insert into test_table values  (2999362,3754090,10)

1 row(s) inserted.

Statement 26

insert into  test_table values (2999362,3807718,8)

1 row(s) inserted.

Statement 27

insert into test_table values  (2999362,3991003,9)

1 row(s) inserted.

Statement 28

insert into  test_table values (2999362,5475332,7)

1 row(s) inserted.

Statement 29

insert into  test_table values (2999362,5475332,5)

1 row(s) inserted.

Statement 30

insert into  test_table values (2999362 ,10750089,4)

1 row(s) inserted.

Statement 31

insert into  test_table values (2999362, 11150508,6)

1 row(s) inserted.

Statement 32

insert into  test_table values (2999362, 12158176,3)

1 row(s) inserted.

Statement 33

insert into  test_table values (2999362, 21065699,1)

1 row(s) inserted.

Statement 34

insert into  test_table values (2999362, 21065699,2)

1 row(s) inserted.

Statement 35
```
commit
```
```
Statement processed.
```

Statement 36

select * from test_table


ORD PERSON_NO FLAG
2999362 3754090 10
2999362 3807718 8
2999362 3991003 9
2999362 5475332 7
2999362 5475332 5
2999362 10750089 4
2999362 11150508 6
2999362 12158176 3
2999362 21065699 1
2999362 21065699 2
2999362 3754090 10
2999362 3807718 8
2999362 3991003 9
2999362 5475332 7
2999362 5475332 5
2999362 10750089 4
2999362 11150508 6
2999362 12158176 3
2999362 21065699 1
2999362 21065699 2
2999362 3754090 10
2999362 3807718 8
2999362 3991003 9
2999362 5475332 7
2999362 5475332 5
2999362 10750089 4
2999362 11150508 6
2999362 12158176 3
2999362 21065699 1
2999362 21065699 2

30 rows selected.

ORD	PERSON_NO	FLAG
2999362	3754090	10
2999362	3807718	8
2999362	3991003	9
2999362	5475332	7
2999362	5475332	5
2999362	10750089	4
2999362	11150508	6
2999362	12158176	3
2999362	21065699	1
2999362	21065699	2
2999362	3754090	10
2999362	3807718	8
2999362	3991003	9
2999362	5475332	7
2999362	5475332	5
2999362	10750089	4
2999362	11150508	6
2999362	12158176	3
2999362	21065699	1
2999362	21065699	2
2999362	3754090	10
2999362	3807718	8
2999362	3991003	9
2999362	5475332	7
2999362	5475332	5
2999362	10750089	4
2999362	11150508	6
2999362	12158176	3
2999362	21065699	1
2999362	21065699	2

Statement 37

create table test_table (ord number,person_no number , flag number)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 38

insert into test_table values  (2999362,3754090,10)

1 row(s) inserted.

Statement 39

insert into  test_table values (2999362,3807718,8)

1 row(s) inserted.

Statement 40

insert into test_table values  (2999362,3991003,9)

1 row(s) inserted.

Statement 41

insert into  test_table values (2999362,5475332,7)

1 row(s) inserted.

Statement 42

insert into  test_table values (2999362,5475332,5)

1 row(s) inserted.

Statement 43

insert into  test_table values (2999362 ,10750089,4)

1 row(s) inserted.

Statement 44

insert into  test_table values (2999362, 11150508,6)

1 row(s) inserted.

Statement 45

insert into  test_table values (2999362, 12158176,3)

1 row(s) inserted.

Statement 46

insert into  test_table values (2999362, 21065699,1)

1 row(s) inserted.

Statement 47

insert into  test_table values (2999362, 21065699,2)

1 row(s) inserted.

Statement 48
```
commit
```
```
Statement processed.
```

Statement 49

delete from test_table

40 row(s) deleted.

Statement 50

insert into test_table values  (2999362,3754090,10)

1 row(s) inserted.

Statement 51

insert into  test_table values (2999362,3807718,8)

1 row(s) inserted.

Statement 52

insert into test_table values  (2999362,3991003,9)

1 row(s) inserted.

Statement 53

insert into  test_table values (2999362,5475332,7)

1 row(s) inserted.

Statement 54

insert into  test_table values (2999362,5475332,5)

1 row(s) inserted.

Statement 55

insert into  test_table values (2999362 ,10750089,4)

1 row(s) inserted.

Statement 56

insert into  test_table values (2999362, 11150508,6)

1 row(s) inserted.

Statement 57

insert into  test_table values (2999362, 12158176,3)

1 row(s) inserted.

Statement 58

insert into  test_table values (2999362, 21065699,1)

1 row(s) inserted.

Statement 59

insert into  test_table values (2999362, 21065699,2)

1 row(s) inserted.

Statement 60
```
commit
```
```
Statement processed.
```

Statement 61

create table test_table (ord number,person_no number , flag number)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 62

insert into test_table values  (2999362,3754090,10)

1 row(s) inserted.

Statement 63

insert into  test_table values (2999362,3807718,8)

1 row(s) inserted.

Statement 64

insert into test_table values  (2999362,3991003,9)

1 row(s) inserted.

Statement 65

insert into  test_table values (2999362,5475332,7)

1 row(s) inserted.

Statement 66

insert into  test_table values (2999362,5475332,5)

1 row(s) inserted.

Statement 67

insert into  test_table values (2999362 ,10750089,4)

1 row(s) inserted.

Statement 68

insert into  test_table values (2999362, 11150508,6)

1 row(s) inserted.

Statement 69

insert into  test_table values (2999362, 12158176,3)

1 row(s) inserted.

Statement 70

insert into  test_table values (2999362, 21065699,1)

1 row(s) inserted.

Statement 71

insert into  test_table values (2999362, 21065699,2)

1 row(s) inserted.

Statement 72
```
commit
```
```
Statement processed.
```

Statement 73

select * from test_table


ORD PERSON_NO FLAG
2999362 3754090 10
2999362 3807718 8
2999362 3991003 9
2999362 5475332 7
2999362 5475332 5
2999362 10750089 4
2999362 11150508 6
2999362 12158176 3
2999362 21065699 1
2999362 21065699 2
2999362 3754090 10
2999362 3807718 8
2999362 3991003 9
2999362 5475332 7
2999362 5475332 5
2999362 10750089 4
2999362 11150508 6
2999362 12158176 3
2999362 21065699 1
2999362 21065699 2

20 rows selected.

ORD	PERSON_NO	FLAG
2999362	3754090	10
2999362	3807718	8
2999362	3991003	9
2999362	5475332	7
2999362	5475332	5
2999362	10750089	4
2999362	11150508	6
2999362	12158176	3
2999362	21065699	1
2999362	21065699	2
2999362	3754090	10
2999362	3807718	8
2999362	3991003	9
2999362	5475332	7
2999362	5475332	5
2999362	10750089	4
2999362	11150508	6
2999362	12158176	3
2999362	21065699	1
2999362	21065699	2

Statement 74

select * from test_table


ORD PERSON_NO FLAG
2999362 3754090 10
2999362 3807718 8
2999362 3991003 9
2999362 5475332 7
2999362 5475332 5
2999362 10750089 4
2999362 11150508 6
2999362 12158176 3
2999362 21065699 1
2999362 21065699 2
2999362 3754090 10
2999362 3807718 8
2999362 3991003 9
2999362 5475332 7
2999362 5475332 5
2999362 10750089 4
2999362 11150508 6
2999362 12158176 3
2999362 21065699 1
2999362 21065699 2

20 rows selected.

ORD	PERSON_NO	FLAG
2999362	3754090	10
2999362	3807718	8
2999362	3991003	9
2999362	5475332	7
2999362	5475332	5
2999362	10750089	4
2999362	11150508	6
2999362	12158176	3
2999362	21065699	1
2999362	21065699	2
2999362	3754090	10
2999362	3807718	8
2999362	3991003	9
2999362	5475332	7
2999362	5475332	5
2999362	10750089	4
2999362	11150508	6
2999362	12158176	3
2999362	21065699	1
2999362	21065699	2

Statement 75

delete from test_table

20 row(s) deleted.

Statement 76
```
commit
```
```
Statement processed.
```
Statement 77
```
select * from test_table
```
```
no data found
```

Statement 78

insert into test_table values  (2999362,3754090,10)

1 row(s) inserted.

Statement 79

insert into  test_table values (2999362,3807718,8)

1 row(s) inserted.

Statement 80

insert into test_table values  (2999362,3991003,9)

1 row(s) inserted.

Statement 81

insert into  test_table values (2999362,5475332,7)

1 row(s) inserted.

Statement 82

insert into  test_table values (2999362,5475332,5)

1 row(s) inserted.

Statement 83

insert into  test_table values (2999362 ,10750089,4)

1 row(s) inserted.

Statement 84

insert into  test_table values (2999362, 11150508,6)

1 row(s) inserted.

Statement 85

insert into  test_table values (2999362, 12158176,3)

1 row(s) inserted.

Statement 86

insert into  test_table values (2999362, 21065699,1)

1 row(s) inserted.

Statement 87

insert into  test_table values (2999362, 21065699,2)

1 row(s) inserted.

Statement 88

select * from test_table


ORD PERSON_NO FLAG
2999362 3754090 10
2999362 3807718 8
2999362 3991003 9
2999362 5475332 7
2999362 5475332 5
2999362 10750089 4
2999362 11150508 6
2999362 12158176 3
2999362 21065699 1
2999362 21065699 2

10 rows selected.

Statement 89
```
commit
```
```
Statement processed.
```

ORD	PERSON_NO	FLAG
2999362	3754090	10
2999362	3807718	8
2999362	3991003	9
2999362	5475332	7
2999362	5475332	5
2999362	10750089	4
2999362	11150508	6
2999362	12158176	3
2999362	21065699	1
2999362	21065699	2

Statement 90

select * from test_table


ORD PERSON_NO FLAG
2999362 3754090 10
2999362 3807718 8
2999362 3991003 9
2999362 5475332 7
2999362 5475332 5
2999362 10750089 4
2999362 11150508 6
2999362 12158176 3
2999362 21065699 1
2999362 21065699 2

10 rows selected.

ORD	PERSON_NO	FLAG
2999362	3754090	10
2999362	3807718	8
2999362	3991003	9
2999362	5475332	7
2999362	5475332	5
2999362	10750089	4
2999362	11150508	6
2999362	12158176	3
2999362	21065699	1
2999362	21065699	2

Additional Information

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