SQL> select * from t1 where x like'A_B';
X
----------
A%B
AB
A_B
SQL> select * from t1 where x like 'A\_B' escape '\';
SQL> select * from t1 where x like 'A!_B' escape '!';
select sal from scott.empv where sal not in (800,1100,null);
notin 里面不要出现空值null
select * from nls_database_parameters;
export nls_lang=AMERICAN_AMERICA.AL32UTF8
set pages 1000
set line 120
set long 10000
set time on
set feed on
define _editor="vim"
select ename from emp where ename = '&xxx';
select '&&a','&a','&a' from dual;
&&会执行define定义一下a,后面的不会再重新输入,而是去引用定义的a
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23562295/viewspace-713483/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23562295/viewspace-713483/