Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Manage Transaction Isolation Level
How To Manage Transaction Isolation Level? - Oracle DBA FAQ - Introduction to PL/SQL
✍: FYIcenter.com
Transaction isolation level can be managed in a procedure by using the SET TRANSACTION and COMMIT statements. Here is a sample script on how to manage transaction isolation level:
SQL> CREATE OR REPLACE PROCEDURE HR.TOTAL_SALARY AS 2 total_salary NUMBER(12,2); 3 BEGIN 4 SET TRANSACTION READ ONLY; 5 SELECT SUM (salary) INTO total_salary FROM employees; 6 DBMS_OUTPUT.PUT_LINE('Total salary 1: ' 7 || total_salary); 8 -- Other sessions may change salaries of some records 9 SELECT SUM (salary) INTO total_salary FROM employees; 10 DBMS_OUTPUT.PUT_LINE('Total salary 2: ' 11 || total_salary); 12 COMMIT; 13 END; 14 / SQL> EXECUTE TOTAL_SALARY; Total salary 1: 691400 Total salary 2: 691400
"READ ONLY" transaction level takes a read only snapshot of the database. This allows other sessions to update the database without any locks. All queries in the session will produces identical results. So both SELECT statements in this script will return the same value guaranteed.
2007-04-26, 7007👍, 0💬
Popular Posts:
What invokes a thread's run() method? After a thread is started, via its start() method of the Threa...
Rachel opened her math book and found that the sum of the facing pages was 245. What pages did she o...
What is CMM and different levels? explain? The Capability Maturity Model (CMM) is a process capabili...
What Are the Parameter Modes Supported by PL/SQL? - Oracle DBA FAQ - Creating Your Own PL/SQL Proced...
.NET INTERVIEW QUESTIONS - What is the difference between System exceptions and Application exceptio...