SQL如下:
select distinct b.COLUMN_NAME,b.comments,a.column_id
from user_tab_columns a,user_col_comments b where a.column_name=b.column_name and b.table_name=upper('YFRAME_STU') order by a.column_id;
SQL如下:
select distinct b.COLUMN_NAME,b.comments,a.column_id
from user_tab_columns a,user_col_comments b where a.column_name=b.column_name and b.table_name=upper('YFRAME_STU') order by a.column_id;