[20150831]中文符号在sql语句.txt
--今天在检查代码时发现sql语句中存在全角的等号"=",很明显oracle并没有报错。
--实际上itpub上以前有人提到全角","也不会报错。
--自己也测试一下:
SCOTT@test> @ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.3.0 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
SCOTT@test> select deptno,dname,loc from dept where deptno = 10;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
--可以发现执行正常。如果在10g,可以发现会报错。
SCOTT@test> @ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- ----------------------------------------------------------------
x86_64/Linux 2.4.xx 10.2.0.4.0 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
SCOTT@test> select deptno,dname,loc from dept where deptno = 10;
select deptno,dname,loc from dept where deptno = 10
*
ERROR at line 1:
ORA-00911: invalid character
SCOTT@test> select deptno,dname,loc from dept where deptno = 10;
select deptno,dname,loc from dept where deptno = 10
*
ERROR at line 1:
ORA-00911: invalid character
SCOTT@test> select deptno,dname,loc from dept where deptno = 10;
DEPTNO DNAME LOC
------------ -------------- -------------
10 ACCOUNTING NEW YORK