Oracle创建小写的表名及查询

最新推荐文章于 2025-04-28 16:48:08 发布

原创最新推荐文章于 2025-04-28 16:48:08 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle 小写表名

Oracle 专栏收录该内容

120 篇文章

订阅专栏

本文演示了在Oracle数据库中使用SQL进行基本操作的过程，包括显示当前用户名、查询用户拥有的对象、创建表、描述表结构等步骤。通过这些操作，读者可以了解到如何在Oracle环境中执行常见的数据定义语言（DDL）任务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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