Live SQL

DDL commit

View All Public Scripts Login to Run Script

Script Name DDL commit
Visibility Unlisted - anyone with the share link can access
Description No description provided
Contributor Franck Pachot
Created Monday March 27, 2017

Statement 1

create table DEMO (n number)

Table created.

Statement 2

insert into DEMO values(1)

1 row(s) inserted.

Statement 3
```
create table TABLE (n number)
```
```
ORA-00903: invalid table name 
```
More Details: https://docs.oracle.com/error-help/db/ora-00903
Statement 4
```
rollback
```
```
Statement processed.
```
Statement 5
```
select * from DEMO
```
```
no data found
```

Statement 6

insert into DEMO values(1)

1 row(s) inserted.

Statement 7

create table DEMO (n number)

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

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

Statement 8
```
rollback
```
```
Statement processed.
```
Statement 9
```
select * from DEMO
```
```
N
1
```

Additional Information

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