oracle 查询字段备注

select
    A.column_name 字段名,B.comments 备注
from
    user_tab_columns A,user_col_comments B
where
    A.Table_Name = B.Table_Name
    and A.Column_Name = B.Column_Name
    and A.Table_Name = 'TBICS_MATCH_CONTROL'

posted @ 2012-12-18 12:04  superstar  阅读(507)  评论(0编辑  收藏  举报