connect scott/tiger set linesize 100 select table_name from user_tables; select * from emp; update emp set sal=900 where empno=7369; -- valeur d'origine 800 SAVEPOINT SP1; update emp set sal=700 where empno=7369; rollback to sp1; update emp set sal=700 where empno=7369; savepoint sp2; update emp set sal=600 where empno=7369; rollback to sp1; rollback to sp2; -- :-) insert into emp (empno, ename, hiredate, sal) values (9000, 'loic', '23/06/2009', 2000); -- connect / -- juste pour jouer avec les écritures des fichiers de journalisation desc v$log select group#, sequence#, members, status from v$log; alter system switch logfile; alter system checkpoint; -- scott/tiger update emp set sal=1700 where empno=8000;