SQL % NOTFOUND and SQL % NOTFOUND

SQL % NOTFOUND and SQL % NOTFOUND

SQL % NOTFOUND is a Boolean value. Interacts with the latest SQL statement (update, insert, delete, select). If the latest SQL statement does not involve any rows, true is returned. Otherwise, false is returned. Such statements are very useful in practical applications. For example, if you want to update a row of data, you can perform the operation if it is not found. For example:

Begin

Update salary set bonus = 1000 where emp_id = 10;

If SQL % notfound then

Insert salary (bonus) valuees (100 );

End if;

.................

When the row record with update emp_id 10 does not exist, an exception is thrown.