plsql_一

plsql_1忽略替换变量 1:set ESCPAE \2:set DEFINE OFF改变替换变量字符setDEFFINE ^ select department_

plsql_1


忽略替换变量


1:set ESCPAE '\'

2:set DEFINE OFF



改变替换变量字符

set  DEFFINE ^


select department_name

from departments

where department_id = ^dept_id


enter value for dept_id



set define character(任意有效字符)