select &a from dual;
define a=10;
解除变量: undifine a;
先编辑文件01.sql:
select &1 , &2 from dual; /
然后在sqlplus中执行:
@ /home/oracle 01.sql 1 2