declare lc_status:='XXstatus'; Begin Update xxtable set Status_fg=lc_status where con_bill_id=1234;
-- here i need to display how rows were updated.
end;
declare lc_status:='XXstatus'; Begin Update xxtable set Status_fg=lc_status where con_bill_id=1234; dbms_output.put_line(to_char(SQL%ROWCOUNT)||' rows were updated'); end;
variable row_up varchar(30);
declare lc_status:='XXstatus'; Begin Update xxtable set Status_fg=lc_status where con_bill_id=1234; :row_up:=(SQL%ROWCOUNT|| 'ROWS updated'); end; /
print row_up
Do i need to write in PL/SQL or is it possible in SQL query?