SELECT column_name,
data_type,
data_length,
data_precision,
data_scale
FROM user_tab_columns
WHERE table_name = '表名';
oracle根据表明查询表字段结构
最新推荐文章于 2022-09-01 10:21:28 发布
SELECT column_name,
data_type,
data_length,
data_precision,
data_scale
FROM user_tab_columns
WHERE table_name = '表名';