I am using oracle sql developer.
I have a script that needs to run in Oracle SQL developer. They are multiple update commands.
I would like print out a line of text before each update so that they show in the result window:
for example
my script is:
print 'high school'
update students
set ....
where schooltype ='high school'
print 'middle school'
update students
set ...
where schooltype ='middle school'
apparently the print will not work, so what is the equivalent in oracle. I am using it in oracle sql developer.
Also if I needs roll back the above update, whatever the print command is , will it affect rollback or commit?
Thanks