2 Replies Latest reply on Jan 16, 2014 12:06 PM by Gaurav Nagpal

    print a line of text

    ANNEC

      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