orcale查看表结构、视图结构

问题：如何查看oracle表结构、视图结构？

方法：

表及字段信息

SELECT * FROM cols WHERE TABLE_NAME = 'xxx';

字段注释

SELECT * FROM user_col_comments WHERE TABLE_NAME = 'xxx';

SELECT * FROM all_col_comments WHERE TABLE_NAME = 'xxx';

表/视图名称及说明

SELECT * FROM user_tab_comments WHERE TABLE_NAME = 'xxx';

SELECT * FROM all_tab_cols WHERE table_name ='LBORGANIZATION' and owner='USR_RSXT';

建表信息

SELECT * FROM user_objects WHERE rownum < 10;

查询Oracle数据表结构

SELECT
    cols.Table_name 表名,
    user_tab_comments.comments 表说明,
    cols.Column_Name 字段名称,
    DATA_TYPE 数据类型,
    cols.DATA_LENGTH 数据长度,
    user_col_comments.Comments 字段说明,
    cols.NullAble 是否为空 
FROM
    cols
    LEFT JOIN user_tab_comments ON ( cols.Table_name = user_tab_comments.Table_name )
    LEFT JOIN user_col_comments ON ( cols.Table_name = user_col_comments.Table_name AND 
cols.Column_Name = user_col_comments.Column_Name ) 
GROUP BY
    cols.Table_Name,
    user_tab_comments.comments,
    cols.Column_Name,
    cols.DATA_TYPE,
    cols.DATA_LENGTH,
    user_col_comments.Comments,
    cols.NullAble 
ORDER BY
    cols.Table_Name;

或者

SELECT
    atc.COLUMN_ID,
    atc.COLUMN_NAME,
    atc.data_type,
    max(atc.data_length),
    acc.COMMENTS
FROM
    all_tab_cols atc,
    all_col_comments acc
WHERE
    atc.COLUMN_NAME = acc.COLUMN_NAME AND
    atc.TABLE_NAME = acc.TABLE_NAME AND
    acc.TABLE_NAME = 'XSJBXXB' AND
    atc.OWNER = acc.OWNER AND
    atc.OWNER='USER'
GROUP BY
    atc.COLUMN_ID,
    atc.COLUMN_NAME,
    atc.data_type,
    acc.COMMENTS
ORDER BY
    atc.COLUMN_ID asc

参考：

https://blog.csdn.net/Little_fxc/article/details/127203599