Saving and Running Scripts

If a set of SQL or iSQL*Plus commands will be used over and over again, it makes sense to save it as a script in a central location and retrieve it when it needs to be run. iSQL*Plus makes it easy to save and retrieve scripts.

Janice decides that the iSQL*Plus script she wrote for displaying salaries by department will be used by every department manager, so she will save it on a network disk drive that is accessible to all of the managers. She clicks the Save Script button at the bottom of the Work Screen.

This brings up the Save As dialog box. Janice saves the contents of the Work Screen to the directory I:\Common\SQLScripts.

To retrieve a script, Janice clicks the Browse button on the Work Screen and navigates to the directory containing the script. She double-clicks the filename to be retrieved, and it is placed in the File or URL text box. She clicks the Load Script button to bring the script into the Work Screen. If Janice knew the full pathname ahead of time, she could also type that directly into the File or URL text box, without needing to use the Browse function.