==== How to get the structure of tables and views in ORACLE? ====

whitelang

How to get the structure of tables and views in ORACLE?

For example, you can check it by querying the sysobjects table in SQL.

What to do in Oracle?

布瑞斯塔

select DBMS_METADATA.GET_DDL (object type, object name) from dual;

Object type:
CLUSTER
TABLE table
INDEX
REF_CONSTRAINT
CONSTRAINT
VIEW view
TYPE
FUNCTION
PROCEDURE
PACKAGE
SEQUENCE
TRIGGER
SYNONYM
DB_LINK

Such as:
select DBMS_METADATA.GET_DDL('TABLE','MYTABLE') from dual;

布瑞斯塔

If you want to obtain the structure of multiple tables at the same time:
select DBMS_METADATA.GET_DDL('TABLE',table_name) from USER_TABLES;