Coder Tutorial

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;