Oracle Sql Developer ver - 2.1.1.64
的区分大小写问题
我刚开始使用“Oracle Sql Developer”工具，在创建和调用表时似乎区分大小写。我一直假设Oracle作为数据库不区分大小写。当前版本的数据库是10.2.0.4.0。
例：
CREATE TABLE T1
( c1 VARCHAR2 (50),
c2 VARCHAR2 (50)
);
SELECT C1, C2 FROM t1;
-- This is fine. No errors
SELECT c1, c2, FROM t1;
/*
Error starting at line 18 in command:
SELECT c1, c2, from t1
Error at Command Line:18 Column:15
Error report:
SQL Error: ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:
*Action:
*/
没有找到相关结果
已邀请:
1 个回复
扭湘阀柿蹄
SQL> CREATE TABLE T1 ( c1 VARCHAR2 (50), c2 VARCHAR2 (50) ); Table created. SQL> SELECT C1, C2 FROM t1; no rows selected SQL> SELECT c1, c2, FROM t1; SELECT c1, c2, FROM t1 * ERROR at line 1: ORA-00936: missing expression