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

Get Oracle SQL Developer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.