Oracle查询表结构SQL语句

Oracle查询表结构SQL语句

查询SQL：
SELECT AT.TABLE_NAME AS 表名,
ATC.COMMENTS AS 表注释,
UTC.COLUMN_NAME AS 字段名称,
UCC.COMMENTS AS 字段注释,
UTC.DATA_TYPE AS 字段类型,
UTC.DATA_TYPE AS 字段长度,
UTC.NULLABLE AS 是否为空,
UTC.COLUMN_ID AS 排序
FROM SYS.ALL_TABLES AT
LEFT JOIN SYS.ALL_TAB_COMMENTS ATC ON AT.OWNER = ATC.OWNER AND AT.TABLE_NAME = ATC.TABLE_NAME
LEFT JOIN SYS.USER_TAB_COLUMNS UTC ON AT.TABLE_NAME = UTC.TABLE_NAME
LEFT JOIN SYS.user_col_comments UCC ON UCC.TABLE_NAME = UTC.TABLE_NAME AND UCC.COLUMN_NAME = UTC.COLUMN_NAME
WHERE AT.OWNER = ‘xxxx’