oracle中的表都要大写，不大写就要…

oracle中的表都要大写，不大写就要加双引号：（这一般是很奇葩的情况）

--------用powerdesigner 建表出来的sql就容易加“”
 

举例：

SQL> select table_name from user_tables where table_name='tmp_T_FUNCTION';

TABLE_NAME

------------------------------

tmp_T_FUNCTION

SQL> select * from tmp_T_FUNCTION;

select * from tmp_T_FUNCTION

              *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> drop table tmp_T_FUNCTION;

drop table tmp_T_FUNCTION

            *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> select * from "tmp_T_FUNCTION";

no rows selected