Home > database >  Ask a question about implicit cursor
Ask a question about implicit cursor

Time:01-07

Small white to ask a question
The attribute of implicit cursor
FOUND and SQL SQL % % NOTFOUND. Can't use dbms_output put_line to output?
When I test has been an error, only the SQL % ROWCOUNT can this output,
The test code is as follows:
Declare
Tname varchar2 (10);
The begin
The update test12 set name='TMD' where pid in (1, 2);
FOUND DBMS_OUTPUT. Put_line (SQL %);
NotFound dbms_output. Put_line (SQL %)
end;

This is two attributes can only be used to judge the statement?
  • Related