오라클 정보 쿼리

SELECT a.table_name, column_id, a.column_name, data_type,
data_length,data_precision,data_scale,nullable,data_default,comments
FROM user_tab_columns a,user_col_comments b
WHERE a.table_name=b.table_name
AND a.column_name=b.column_name
ORDER BY table_name,column_id

 

USER_TABLES, ALL_TAB_COLUMNS , ALL_COM_COMMENTS, ALL_TAB_COMMENTS