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, 1668🔥, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...