oracle 查询schema下的所有表, 字段, 和注解
SELECT a.TABLE_NAME, b.column_name, c.COMMENTS ,b.data_type, b.DATA_LENGTH , b.NULLABLE FROM ( select TABLE_NAME from user_tables ) a INNER JOIN user_tab_columns b ON a.TABLE_NAME = b.table_name
LEFT JOIN user_col_comments c ON c.TABLE_NAME = a.TABLE_NAME;
;