日期:2014-05-16 浏览次数:21298 次
select distinct(a.column_id),a.column_name,b.comments
from user_tab_columns a,user_col_comments b
where a.table_name =UPPER( 'dyml01') and b.table_name=UPPER('dyml01') and a.COLUMN_NAME = b.column_name
order by decode(a.column_id,4,1,2,2,1,3)