While entering a SQL statement in Oracle SQL Developer, I saw that I have two choices I either performed the statement " "Or" run script "It seems that there is a similar option available in SQL Maastro, named" Execic Query "and" Execution Script ".
What is the difference between the two?
run statement will list all the results in a sorted table. It will run only the statement under the cursor (or the highlight). When you run the statement (with the holder in any place: in front of it), you will be prompted for bind variables.
e.g.
Choose from customers * where customer_id =: id will point to a value for ID
The script will execute all the statements in the worksheet, and will teach the results of the lessons. This will not prompt you for the values of the bind variable.
Comments
Post a Comment