Oracle PL/SQL – SELECT FOR UPDATE Statement
When you execute SELECT FOR UPDATE statement, database acquires row level lock automatically against all the rows in the CURSOR result set. Locks on the...
Author: Rakesh Panigrahi
Oracle SQL Merge Statement
SQL merge will allow you to perform multiple INSERT, UPDATE and DELETE in a single statement. There are certain situation where you may want to...