oracle 查看数据表结构,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