A transaction acquires a row lock for each row modified by one of the following statements: INSERT , UPDATE , DELETE , MERGE , and SELECT .
docs.oracle.com