查看字段名及数据类型
select * from cols WHERE TABLE_name=upper( ‘表名’)
查看表备注
select * from all_tab_comments where TABLE_name=upper( ‘表名’)
参看列备注
select * from all_col_comments where TABLE_name=upper( ‘表名’)
oracle笔记
最新推荐文章于 2025-04-27 12:28:49 发布
查看字段名及数据类型
select * from cols WHERE TABLE_name=upper( ‘表名’)
查看表备注
select * from all_tab_comments where TABLE_name=upper( ‘表名’)
参看列备注
select * from all_col_comments where TABLE_name=upper( ‘表名’)