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
⇒ General Rules on Data Consistency in Oracle
⇐ Set a READ ONLY Transaction in Oracle
2019-08-19, 1592🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...