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.