Daily Archives Sunday, August 2008

Difference between rollbac and rollback

What is the difference between rollbac and rollback?

SQL> create table t as select 1 x from dual;

Table created.

SQL> update t set x=2;

1 row updated.

SQL> savepoint a;

Savepoint created.

SQL> update t set x=3;

1 row updated.

SQL> rollbac to savepoint a;
Rollback complete.
SQL> select * from t;
         X
———-
         1

WTF! rollbac does not seem to work correctly
Actually, ROLL, ROLLB, [...]