PL/SQL Set Transaction
Oracle PL/SQL Set Transaction Example
COMMIT; SET TRANSACTION READ ONLY NAME 'London'; SELECT customer_id, city FROM customers WHERE customer_id = 1; COMMIT;
COMMIT; SET TRANSACTION READ ONLY NAME 'London'; SELECT customer_id, city FROM customers WHERE customer_id = 1; COMMIT;