This content has been marked as final. Show 2 replies
Look at the PROMPT command.
It won't affect the transaction.
One approach is to use-->DBMS_OUTPUT.PUT_LINE Other solution is create one dummy table with one column and insert the data into that table before update. Thank Gaurav Nagpal.