给oracle 的SQL脚本传参数

SQL脚本内容：

conn  & 1 /& 2
select   count ( * )  from  user_tables;

    exit

调用：

SQL> exit
从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production中断开

C:/>sqlplus /nolog @E:/test.sql scott tiger

SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 12月 4 14:02:45 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

已连接。

  COUNT(*)
----------
         4

从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production中断开

C:/>