Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 807
vipirtti Avatar asked Jan 26 '09 10:01

vipirtti


1 Answers

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).

E.g.

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.

like image 99
Greg Reynolds Avatar answered Nov 10 '22 19:11

Greg Reynolds