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, 1593🔥, 0💬
Popular Posts:
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...