用了楼上朋友说的查询注释:select * from user_col_comments 查出来一大堆,请问在ORACLE里如何单独查询我创建的某个表的字段注释?谢谢
desc user_col_comments里面有表的名称,字段名称,你自己写sql吧
select * from user_col_comments where table_name = &name and column_name = &colname
用comment on 注释 用select user_col_comments得到注释
添加表的注释 comment on column [columnname] is [columnname comment]查询注释 select * From user_col_comments Where table_name = :tablename And column_name = :columnname
sqldev 工具,或者 comment on column [columnname] is [columnname comment] select * from user_commnets.
查出来一大堆,请问在ORACLE里如何单独查询我创建的某个表的字段注释?谢谢
注释
用select user_col_comments得到注释
comment on column [columnname] is [columnname comment]查询注释
select * From user_col_comments
Where table_name = :tablename And column_name = :columnname
select * from user_commnets.