oracle 表字段以及字段注释、类型信息获取

SELECT DISTINCT
    * 
FROM
    (
SELECT
    comments AS "Name",
    a.column_name "Code",
    a.DATA_TYPE AS "DataType",
    b.comments AS "Comment",
    DECODE( c.column_name, NULL, 'FALSE', 'TRUE' ) AS "Primary",
    DECODE( a.NULLABLE, 'N', 'TRUE', 'Y', 'FALSE', '' ) AS "Mandatory" 
FROM
    all_tab_columns a,
    all_col_comments b,
    (
SELECT
    a.constraint_name,
    a.column_name 
FROM
    user_cons_columns a,
    user_constraints 
WHERE
    a.constraint_name = b.constraint_name 
    AND b.constraint_type = 'P' 
    AND a.table_name = upper( 'sys_config' ) 
    ) c 
WHERE
    a.Table_Name = b.table_Name 
    AND a.column_name = b.column_name 
    AND a.Table_Name = upper( 'sys_config' ) 
    AND a.COLUMN_NAME = c.column_name ( + ) 
ORDER BY
    a.COLUMN_ID 
    )