PL/SQL Developer: Multiple statements?
I have a script that generates a text file containing several SQL UPDATE statements:
UPDATE TableX SET Field1 = 'New value 1' WHERE Field2='1';
UPDATE TableX SET Field1 = 'New value 2' WHERE Field2='2';
UPDATE TableX SET Field1 = 'New value 3' WHERE Field2='3';
etc.
When I paste the above block of text into an SQL Window in PL/SQL Developer, it tells me that the semicolon is an invalid character. When I remove it, it informs me that my first statement was not terminated properly.
How do I run these statements in a single execution?
Answer
I think you're using the Test window. This can only execute a single statement. The SQL Window and the Command Window are able to run multiple statements.
If you need to run this in a Test window, you can embed it in a begin..end block to make it a PL/SQL statement block.