select a.comments,b.*
from user_col_comments a,user_tab_columns b
where a.table_name = b.table_name
and a.column_name = b.column_name
from user_col_comments a,user_tab_columns b
where a.table_name = b.table_name
and a.column_name = b.column_name
select a,b from test 但是在ALL_TAB_COLS里加上a b 的comments
能吗?
2 is '日期';
哦这样就行了,,,呵呵