Oracle获取表字段名,字段类型,字段长度,注释
SELECT b.comments as 注释,
a.column_name as 列名,
a.data_type || '(' || a.data_length || ')' as 数据类型,
a.nullable as 是否为空
FROM user_tab_columns a, user_col_comments b
WHERE a.TABLE_NAME = '表名'
and b.table_name = '表名'
and a.column_name = b.column_name
![公众号](https://images.cnblogs.com/cnblogs_com/jichi/1773319/o_200525150353qrcode_for_gh_9280df3f1396_258.jpg)
作者:经典鸡翅
微信公众号:经典鸡翅
如果你想及时得到个人撰写文章,纯java的面试资料或者想看看个人推荐的技术资料,可以扫描左边二维码(或者长按识别二维码)关注个人公众号)。