Execute Statement or Run Script?

While entering a SQL statement in Oracle SQL Developer, I noticed that I have two choices. I can either "Run Statement" or "Run Script". A similar choice seems to be available in SQL Maestro as well, although named "Execute query" and "Execute as script". What exactly is the difference between the two?

1,147 13 13 silver badges 16 16 bronze badges asked Jan 26, 2009 at 10:58 1,078 4 4 gold badges 16 16 silver badges 24 24 bronze badges

2 Answers 2

Run Statement will give you a list of all the results in a sortable table. It will also only run the statement under the cursor (or highlighted). You will be prompted for bind variables when you run the statement (any place holder with : in front of it).

select * from customers where customer_id = :id

will prompt for a value for id

Run Script will execute all statements in the worksheet, and give a text readout of the results. It will not prompt you for the values of bind variables.