Tuesday, 22 May 2012

How can you check if an UPDATE statement in PL/SQL is successfully executed? | PL SQL

 You can use the SQL%NOTFOUND attribute to check if the UPDATE statement has successfully updated any rows or not. This attribute returns the TRUE value if the last executed SQL statement has not affected any rows.