oracle查询表结构信息SQL记录

-- 一下为查询条件
-- atc.owner = '库名' and atc.table_name = '表名'
SELECT DISTINCT
atc.table_name AS "表名"
,atc.column_name AS "字段名"
,atc.data_type AS "字段类型"
,acc.comments AS "字段注释"
FROM
all_tab_columns atc
INNER join all_col_comments acc ON atc.table_name = acc.table_name AND atc.owner = acc.owner AND atc.column_name = acc.column_name
INNER join all_tab_comments atcom ON atc.table_name = atcom.table_name AND atcom.owner = acc.owner AND atcom.table_type = 'TABLE'
INNER join all_tables allt on atc.table_name = allt.table_name AND atc.owner = allt.owner
WHERE
atc.owner = 'ZHGBSYS' and atc.table_name = 'A01'
ORDER BY
atc.table_name;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

select查询字段按需给出即可