ORA-00904/ORA-00942和Oracle 大小写区分

某些软件可以帮助用户自动产生Create table语句，这时需要将双引号去掉。否则会产生上述错误。

create table "t" ( "a" int );
table "t" created.

select A from T;
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 16 Column: 15

select A from "t";
ORA-00904: "A": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 16 Column: 8

相关阅读：