[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