oracle如何查看数据库，表字段的类型

select column_name,data_type,DATA_LENGTH From all_tab_columnswhere table_name=upper('表名') AND owner=upper('数据库登录用户名')//下面是举例：select column_name,data_type,DATA_LENGTH From all_tab_columnswhere table_na

Java&Develop

2672人浏览 · 2022-04-11 10:57:37

Java&Develop · 2022-04-11 10:57:37 发布

select column_name,data_type,DATA_LENGTH From all_tab_columns
where table_name=upper('表名') AND owner=upper('数据库登录用户名')
//下面是举例：
select column_name,data_type,DATA_LENGTH From all_tab_columns
where table_name=upper('t_department') AND owner=upper('scott')