How to run multiple update statements in TOAD for Oracle -


i have 800 update statements want run in toad

update my_table set col1 = 'a' col2 = '1'; update my_table set col1 = 'b' col2 = '2'; update my_table set col1 = 'c' col2 = '3'; update my_table set col1 = 'd' col2 = '4'; 

i have tried:

  • hitting f5
  • selecting , hitting f5
  • wrapping statements in:

    begin (update statements) end; / 

all no avail. pops processing window , says 1 of 800... , never completes first statement.

f9 complete first statement nothing else. ideas? toad v11.5.1.2

i have tried hitting f5, selecting , hitting f5, wrapping statements in:

you don't need wrap update statements within begin-end block. execute script or press f5 update statements in same worksheet.


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

datatable - Matlab struct computations -