Execute Statement or Run Script?

Question

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?

Langelo

Answer 1

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.

Issuant

It looks like they changed the terminology at some point: in SQL Developer 4.0.2.15, there's "Run Statement" and "Run Script", but no "Execute". – Apolitical

I have noticed also that if a single select statement is run as a script, the output is paginated. Not in my view, a terrible useful behavior, but perhaps so to others. To me it is just confusing. – Lipoprotein

Answer 2

I think "Execute Statement" - mean if you want to get results (resultset) "Run Script" - is something you need to execute but don't need a results, like installing database dump, or upgrade script to add columns to the table etc.

Merengue