oracle

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/