查找数据库表的属性，注释等字段，有数据但查不出数据

可能是用户不对

SELECT
    a.COLUMN_NAME 列名,
    b.COMMENTS 注释,
    b.COMMENTS 说明,
    a.DATA_TYPE 数据类型,
    a.DATA_LENGTH 长度,
    (CASE WHEN a.NULLABLE = 'N' THEN 'Y' ELSE 'N' END) 非空
FROM all_tab_columns a
         LEFT JOIN all_col_comments b ON a.OWNER = b.OWNER AND a.TABLE_NAME = b.TABLE_NAME AND a.COLUMN_NAME = b.COLUMN_NAME
WHERE a.OWNER = 'ZWFW_CODE_KF' AND a.TABLE_NAME = 'CODE_RULE_ITEM'
ORDER BY a.TABLE_NAME, a.COLUMN_ID;