isqlplus中替换变量的使用

1，替换变量前跟&或&&或自定义；

select ku_id,&c1  from &t1  where &w1；

原值 1: select ku_id,&c1 from &t1 where &w1
新值 1: select ku_id,ku_lid from wk_t_user where ku_id=1

2，替换变量中&&表示重复引用；

select ku_id,&&c1  from &t1  where &c1 like 'w%';

原值 1: select ku_id,&&c1 from &t1 where &c1 like 'w%'
新值 1: select ku_id,ku_lid from wk_t_user where ku_lid like 'w%'
3，自定义变量；

如：define a=1;

DEFINE A = "1" (CHAR)

可通过define查看所以已定义的变量；

define：

DEFINE _DATE = "08-8月 -08" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "orcl" (CHAR)
DEFINE _USER = "WKADMIN" (CHAR)
DEFINE _PRIVILEGE = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
DEFINE _EDITOR = "Notepad" (CHAR)
DEFINE _O_VERSION = "Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options" (CHAR)
DEFINE _O_RELEASE = "1002000100" (CHAR)
DEFINE C1 = "ku_lid" (CHAR)
DEFINE A = "1" (CHAR)

 

可通过undefien取除已定义的变量或推出isqlplus去除已定义的变量；

如:undefien a;