Oracle创建小写的表名及查询

最新推荐文章于 2021-12-08 09:31:53 发布

lk_db

最新推荐文章于 2021-12-08 09:31:53 发布

阅读量1.2k

点赞数

分类专栏： Oracle 文章标签： oracle 小写表名

本文链接：https://blog.csdn.net/lk_db/article/details/79171864

版权

Oracle 专栏收录该内容

120 篇文章 5 订阅

订阅专栏

SQL> show user
USER is "TEST"

SQL> select object_name,object_type from user_objects;
OBJECT_NAME OBJECT_TYPE
------------------------------ --------------------
BIN$Ys4BOtF4DN7gUwoGqMCmUw==$0 TABLE PARTITION
BIN$Ys4BOtF4DN7gUwoGqMCmUw==$0 TABLE PARTITION
BIN$Ys4BOtF4DN7gUwoGqMCmUw==$0 TABLE PARTITION

SQL> create table 'a' (id int);

create table 'a' (id int)
*
ERROR at line 1:
ORA-00903: invalid table name

SQL> create table "a" (id int);
Table created.

SQL> select * from "a";
no rows selected

SQL> desc a
ERROR:
ORA-04043: object a does not exist

SQL> desc "a"
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(38)

SQL> select object_name,object_type from user_objects where object_name='"a"' ;
no rows selected

SQL> select object_name,object_type from user_objects where object_name like '"a%' ;
no rows selected

SQL> select object_name,object_type from user_objects where object_name like '%a"' ;
no rows selected

SQL> select object_name,object_type from user_objects where object_name like '"a"' ;
no rows selected

SQL> select object_name,object_type from user_objects;
OBJECT_NAME OBJECT_TYPE
------------------------------ --------------------
a TABLE
BIN$Ys4BOtF4DN7gUwoGqMCmUw==$0 TABLE PARTITION
BIN$Ys4BOtF4DN7gUwoGqMCmUw==$0 TABLE PARTITION
BIN$Ys4BOtF4DN7gUwoGqMCmUw==$0 TABLE PARTITION

SQL> select object_name,object_type from user_objects where object_name = 'a' ;
OBJECT_NAME OBJECT_TYPE
------------------------------ --------------------
a TABLE