SELECT Column_Name, DATA_TYPE from cols t1 LEFT JOIN user_objects ON t1.table_name = user_objects.OBJECT_NAMEwhere user_objects.OBJECT_TYPE=‘VIEW‘ AND t1.TABLE_NAME=‘JW_VJK_KCD_3‘
oracle 查询字段类型
原文：https://www.cnblogs.com/supermwb/p/11717202.html
