Oracle Server Manager User's Guide

Running Scripts from the SQL Worksheet

From a SQL Worksheet, you can run any script that contains SQL, PL/SQL, or Server Manager commands. There are three ways to run scripts from a SQL Worksheet:

Clicking Run Script

Choosing Run Script from the Worksheet menu

Executing the Server Manager @ command from the input pane

Click the Run Script button or choose Run Script from the menu to bring up your platform's standard file selection dialog box, which you can then use to select a script to run.

You can also run a script from the input pane of a worksheet by entering an @ command followed by the script name. The following figure illustrates running a script from the input pane of a worksheet. If you enter an @ command without a script name, your platform's standard file selection dialog box appears to allow you to specify a script name.

Figure 9 - 6. Running a Script from the Input Pane

Note: In a script you can run other scripts. In the original script you can include the line @@second_scriptname to run another script called second_scriptname. The @@ command indicates that the second script is in the same directory as the original script.