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
Post a Comment