Detailed explanation of the usage of sql%notfound in oracle Database

SQL%NOTFOUND is a Boolean value. Interacts with the most recent sql statement (update,insert,delete,select) and returns true when the most recent sql statement does not involve any rows. Otherwise, false is returned. Such statements are very useful in practical applications. For example, when you want to update a row of data, if you don't find it, you can do it accordingly. Such as:

Begin update table_name set salary = 10000 where emp_id = 10; if sql%notfound then insert into table_name (id,name,salary) values (",", "); end if;end

For this row of records with a update emp_id of 10, a piece of data is inserted if the number of update influence entries is 0.

The usage of SQL%FOUND is opposite to that of sql%notfound, and it also interacts with the most recent sql statement. If the number of rows affected is greater than 0, it is true.

Otherwise, false.

SQL%ROWCOUNT is null before the execution of the dml statement, and after execution, for the select into statement, the value is 1 for success and 0 for failure.

The above is the detailed explanation of the usage of sql%notfound in the oracle database introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!