获取表的注释

select  a.column_name,b.comments
from user_tab_columns A,user_col_comments B
where a.COLUMN_NAME=b.column_name and  
A.Table_Name = B.Table_Name and A.Table_Name='OA_FINANCE'

posted @ 2008-11-21 17:19  做你所想  阅读(236)  评论(0)    收藏  举报