update tablea set psw='=!>1=!' where id=1;
update tablea set psw='_P_YDY' where id=2;
update tablea set psw='XI)J&4' where id=3;
这三个sql语句做为一个脚本执行,执行到第三句时,会提示4是个变量,要求输入变量值,请问怎样修改可以使psw最终结果为XI)J&4
谢谢
update tablea set psw='_P_YDY' where id=2;
update tablea set psw='XI)J&4' where id=3;
这三个sql语句做为一个脚本执行,执行到第三句时,会提示4是个变量,要求输入变量值,请问怎样修改可以使psw最终结果为XI)J&4
谢谢
用&&表示&
where emp.deptno in (select dept.deptno from dept
where dname = 'R&&D')
order by empno descIf the text 'R&D' had been used instead, you would have been prompted for the D variable.
SQL> select '&test' from dual;'&TEST'
-------
&test关闭变量定义就可以了