批处理文件test.bat如下:
sqlplus user/pwd@ora @test.sql>>test.log
执行的test.sql脚本如下:
SELECT * FROM T1;
SELECT * FROM T2;
SELECT * FROM T3;
我想知道有没办法从test.bat里传参数1,2,3给test.sql,只在tesr.sql里写一条语句:
SELECT * FROM %T;
达到执行上面3条语句的效果?
sqlplus user/pwd@ora @test.sql>>test.log
执行的test.sql脚本如下:
SELECT * FROM T1;
SELECT * FROM T2;
SELECT * FROM T3;
我想知道有没办法从test.bat里传参数1,2,3给test.sql,只在tesr.sql里写一条语句:
SELECT * FROM %T;
达到执行上面3条语句的效果?
