How to pass parameters when sqlplus executes a script file

D: \ test. SQL script:

1. Select& 1From& 2;
2. Exit;

Run the following command to pass the parameter: sqlplus "scott/tiger @ test" @ d: \ test. SQL sysdate dual

Note: The parameter must be represented by & [1-9]. Otherwise, you will be prompted to manually enter the parameter.

1. C: \> sqlplus"Scott/tiger @ test"@ D: \ test. SQL sysdate dual
3. D: \> sqlplus"Scott/tiger @ test"@ D: \ test. SQL sysdate dual
5. SQL * Plus: Release 11.2.0.1.0 ProductionOnTuesday November 1 21:59:00 2011
7. Copyright (c) 1982,201 0, Oracle.AllRights reserved.
10. Connect:
11. OracleDatabase11g Enterprise Edition Release 11.2.0.1.0-Production
12. WithThe Partitioning, OLAP, Data MiningAnd RealApplication Testing options
14. Original Value 1:Select& 1From& 2
15. New value 1:SelectSysdateFromDual
17. SYSDATE
18. --------------
19. September 11-11
21. From OracleDatabase11g Enterprise Edition Release 11.2.0.1.0-Production
22. WithThe Partitioning, OLAP, Data MiningAnd RealApplication Testing options disconnected
23. Open
25. D: \>

If the same value is used repeatedly in the script, IF & 1 = & 2:

D: \ tes2. SQL

1. DeleteScott. empWhere No= & 1OrDeptno = & 2;
2. Commit;

During execution, two parameters must be passed:

1. Sqlplus"Scott/tiger @ test"@ D: \ test2. SQL 10 10

TIPS: If procedure is used, you do not need to pass multiple identical parameters, but only one parameter is required:

D: \ test3. SQL

1. Declare
2. Var_no number: = & 1;
3. Begin
4. DeleteScott. empWhere No= Var_noOrDeptno = var_no;
5. Commit;
6. End;

Sqlplus "scott/tiger @ test" @ d: \ test3. SQL 10