set transaction read only
My problem is like this (below this text is example). I created one table with one column and I have used a set transaction read only option to try it, but I don't know why I got output like this. Why Oracle didn't say ORA-01456:may not perform insert/delete/update operation inside a READ ONLY transaction
SQL> set transaction read only;
Transaction set.
SQL> update tabela
2 set x=5;
5 rows updated.
SQL> select *
2 from tabela;
X
----------
5
5
5
5
5
|