我的查询结果如下:
用户名:userBank,表空间:tp_bank,查询用户下的表有表,但是可以查询大写表名称的表,不能查询小写表名称的表?请问哪里出了问题?
SQL>
select username,default_tablespace from user_users;
USERNAME
--------------------------------------------------------------------------------
DEFAULT_TABLESPACE
--------------------------------------------------------------------------------
USERBANK
TP_BANK
SQL> show user;
USER is "USERBANK"
SQL> select table_name from user_tables;
TABLE_NAME
--------------------------------------------------------------------------------
cardType
customerInfo
deposit
manager
moneyType
role
BANKROLE
CARDINFO
TRANSACTION
9 rows selected.
SQL> select * from cardinfo;
no rows selected
SQL> select * from transaction;
no rows selected
SQL> select * from deposit;
select * from deposit
*
ERROR at line 1:
ORA-00942: table or view does not exist