Oracle创建小写的表名及查询_oracle表名是小写字母,查询语句怎么写-优快云博客

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

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