-- 获取T_POL_CUSTOMER_NEW表的字段名、字段类型、默认值、是否允许为空、字段说明
select t1.column_name,data_type,data_default,nullable,comments from (
select table_name,column_name,data_type,data_default,nullable from user_tab_cols where Table_Name='T_POL_CUSTOMER_NEW'
)t1
RIGHT JOIN
(
select column_name,comments from user_col_comments where Table_Name='T_POL_CUSTOMER_NEW'
)t2
on t1.column_name=t2.column_name;
获取结果:
注:如果需要获取字段的其他属性,可以先查询 user_tab_cols 和 user_col_comments 中有什么再去进行筛选。
eg:
select * from user_tab_cols where Table_Name='T_POL_CUSTOMER_NEW';
select * from user_col_comments where Table_Name='T_POL_CUSTOMER_NEW';