Execute Statement or Run Script?

sql database oracle oracle-sqldeveloper
vipirtti picture vipirtti · Jan 26, 2009 · Viewed 35.7k times · Source

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?

Answer

Greg Reynolds picture Greg Reynolds · Jan 26, 2009

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.

Related questions

How to enter special characters like "&" in oracle database?

I want to insert special character & in my insert statement. My insert is: INSERT INTO STUDENT(name, class_id) VALUES ('Samantha', 'Java_22 & Oracle_14'); If I try to run this query I am getting a popup and it …

Read More
copy from one database to another using oracle sql developer - connection failed

I am trying to copy a table from one database to another using oracle sql developer. I have the username, password and SIDs. copy from uname1/password1@SID1 to uname2/pwd2@SID2 insert table1 (*) using (select * from message_table); However …

Read More
Oracle SQL Developer copy database step by step

I'm having big trouble in copying an Oracle DB to the same server but with another name, to use as a development DB. I'm used to SQL Server, I'm new to Oracle (11g). I wanted to use the 'Database copy' …

Read More