Collections:
Restrictions in a READ ONLY Transaction in Oracle
What Are the Restrictions in a READ ONLY Transaction in Oracle?
✍: FYIcenter.com
There are lots of restrictions in a READ ONLY transaction:
The tutorial exercise below shows you some of the restrictions:
SQL> connect HR/fyicenter SQL> SET TRANSACTION READ ONLY; Transaction set. SQL> SET TRANSACTION READ WRITE; ORA-01453: SET TRANSACTION must be first statement of transaction SQL> INSERT INTO fyi_links (url, id) 2 VALUES ('sql.com', 113); ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction SQL> DELETE FROM fyi_links where id = 110; ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction SQL> SELECT * FROM fyi_links; ID URL NOTES COUNTS CREATED ------- ---------------- ---------- ---------- --------- 101 FYICENTER.COM 07-MAY-06 110 CENTERFYI.COM 07-MAY-06
Â
2019-08-19, 1119👍, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...