Databases Reference
In-Depth Information
However, the substitution is performed twice. The first substitution variable
&&DeptList has a double ampersand, and therefore its value is retained when
&DeptList is encountered later in the script.
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 Workspace area.
