How to print in pl/SQL
Declare
The begin
Dbms_output. Put_line (delete from... The where... The in... )
The end;
I want to print the results of this statement you can write it

CodePudding user response:

Can't

Dbms_output. Put_line (here is a string argument)

CodePudding user response:

Then I need to print the result of the statement, how to get the

CodePudding user response:

To string concatenation, cannot do directly

CodePudding user response:

I just want to print out the result in the execution of the delete statement, how to write, wait,

CodePudding user response:

The delete statement has the result?
Is to want to know how many rows the delete?
Execute the delete statement first, and then print the cursor SQL % ROWCOUNT
The delete...
Dbms_output. Put_line (SQL % ROWCOUNT);