select column_name,data_type,DATA_LENGTH From all_tab_columns
where table_name=upper('表名') AND owner=upper('数据库登录账号')
Oracle 用SQL查看表字段 及表字段类型及类型长度
最新推荐文章于 2024-04-02 10:01:37 发布
select column_name,data_type,DATA_LENGTH From all_tab_columns
where table_name=upper('表名') AND owner=upper('数据库登录账号')