Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

print a line of text

ANNECJan 10 2014 — edited Oct 20 2017

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

This post has been answered by Gaurav Nagpal on Jan 16 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2014
Added on Jan 10 2014
2 comments
664 views