select * from v$transaction;
create table t as select rownum n from all_objects where rownum < 1000;
select * from v$transaction;
select * from t where n=1;
select * from v$transaction;
update t set n=2000 where n=3000;
select * from v$transaction;
delete from t where n=3000;
select * from v$transaction;
alter table t add constraint pk_t primary key(n);
select * from v$transaction;
insert into t values(500);
insert into t values(500)
select * from v$transaction;
create trigger trig_t before insert on t
begin
	raise_application_error(-20001,'trigger not allows to insert to this table');
end;
/
select * from v$transaction;
insert into t values(1001)
select * from v$transaction;
savepoint sp1;
select * from v$transaction;
create procedure test_p as
begin
	dbms_output.put_line('selam');
end;
/
select * from v$transaction;
exec test_p;
select * from v$transaction;
update t set n=1000 where n=999;
select * from v$transaction;