Oracle Database Discussions

Hi every one

Here is simple test case .......

<quote>
SQL> conn scott/tiger@orcl
Connected.
SQL> create table a(id number) ;
Table created.

SQL> insert into a values(12);
1 row created.

SQL> create table aa(sal number) ;
Table created.

SQL> insert into a values(12);
1 row created.

SQL> insert into a values(123);
1 row created.

SQL> rollback;
Rollback complete.

SQL> select * from a;
ID
----------
12

SQL>

<quote>

From above test i found that the first inserted statement is not rollback ?My question

1.) Is this means that DDL's auto commits the DML's if so then what will we call this phenomenon ?

2.) How oracle works ? if we considered the same above example where the second table created in another session(say hr) and inserted few rows and finally comeback to scott sesion and fired rollback then what will happen in this case ?

Kindly explain in details


Warm Regards

techie