oracle数据表的相关查看表结构信息

使用某个用户连接数据库

SQL> conn system/oracle
Connected.

SQL> select * from system.help where rownum<6;

断开当前用户连接

SQL> disconn;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select * from system.help where rownum<6;
SP2-0640: Not connected

查看数据表的结构信息

SQL> desc system.help;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TOPIC                                     NOT NULL VARCHAR2(50)
 SEQ                                       NOT NULL NUMBER
 INFO                                               VARCHAR2(80)

查询数据库对象的相关信息

SQL> select table_name,tablespace_name,owner from dba_tables where owner='SYSTEM';

TABLE_NAME           TABLESPACE_NAME      OWNER
-------------------- -------------------- --------------------
LOGMNR_SESSION_EVOLV SYSAUX               SYSTEM
E$

LOGMNR_GLOBAL$       SYSAUX               SYSTEM
LOGMNR_PDB_INFO$     SYSAUX               SYSTEM
LOGMNR_DID$          SYSAUX               SYSTEM
LOGMNR_UID$          SYSAUX               SYSTEM
LOGMNRGGC_GTLO       SYSTEM               SYSTEM
LOGMNRGGC_GTCS       SYSTEM               SYSTEM
LOGMNRC_DBNAME_UID_M SYSAUX               SYSTEM

查询当前用户的会话信息

SQL> select username,terminal from v$session where username='SYS';

USERNAME             TERMINAL
-------------------- ------------------------------
SYS                  pts/2
SYS                  UNKNOWN

Mr丶点心永久会员

打赏 收藏 海报 链接