交互式变量
select &a from dual;
提前定义变量
define a=10;
select &a from dual;
解除变量: undifine a;
参数变量
先编辑文件01.sql:
select &1 , &2 from dual; /
然后在sqlplus中执行:
@ /home/oracle 01.sql 1 2
select &a from dual;
define a=10;
select &a from dual;
解除变量: undifine a;
先编辑文件01.sql:
select &1 , &2 from dual; /
然后在sqlplus中执行:
@ /home/oracle 01.sql 1 2
转载于:https://www.cnblogs.com/Blue2017/p/7230929.html