O'Reilly logo

Oracle SQL Developer by Ajith Narayanan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Script Runner/Running scripts

Possibly, one of the most commonly used group of SQL*Plus commands are those that run scripts: @, @@, and start. The script runner emulates a limited set of SQL*Plus features. You can often enter SQL and SQL*Plus statements and execute them by clicking the Run Script icon, which is shown in the next screenshot. The Script Output pane displays the output.

Script Runner/Running scripts

You need to use @@ when running one script that calls a second or third script. In this case, it is necessary to set the path for the top-level file.

For either, set the path navigating to Database | Worksheet. Press F5 to run the script.

Tip

Set the default path for executing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required