atomicity: roll back and commit : Transaction Rollback Commit « Table « Oracle PL / SQL

1. Oracle PL / SQL
2. Table
3. Transaction Rollback Commit

atomicity: roll back and commit

   
SQL>
SQL>
SQL> create table t ( x number(1) );

Table created.

SQL> /

SQL>  insert into t values ( 1 );

1 row created.

SQL> insert into t values ( 2 );

1 row created.

SQL> /

1 row created.

SQL> rollback;

Rollback complete.

SQL> select * from t;

no rows selected

SQL> insert into t values ( 1 );

1 row created.

SQL> insert into t values ( 2 );

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t;

         X
----------
         1
         2

SQL> /

         X
----------
         1
         2

SQL>
SQL> drop table t;

Table dropped.

   
    
  

Related examples in the same category