@ CLPPlus command

The @ CLPPlus command is an alias for the START CLPPlus command. It can be used to run a CLPPlus script file.

Invocation

You must run this command from the CLPPlus interface.

Authorization

None

Required connection

None

Command syntax

Command parameters

path

Specifies the path, either absolute or relative, to the script file that contains SQL statements and commands to run. If no path is specified, the current directory is used.

URL

Specifies the URL to the script file that contains SQL statements and commands to run. The URL must start with http:// or https://.

script-file

Specifies the script file name that contains SQL statements and commands to run.

Example

A script called employee_count.sql contains the following lines:

ACCEPT dept_id PROMPT "Enter Department ID code : "
SELECT COUNT(*) FROM employee WHERE workdept = &dept_id;

The @ command can be used to run the script as follows:

SQL> @ employee_count
Enter Department ID code : 'E21'

Original statement:SELECT AVG(salary) FROM employee WHERE workdept = &dept_id
New statement with substitutions:SELECT AVG(salary) FROM employee WHERE workdept = 'E21'
                                         1
------------------------------------------
       47086.66666666666666666666666666667