oracle 查询字段类型
SELECT Column_Name, DATA_TYPE from cols t1 LEFT JOIN user_objects ON t1.table_name = user_objects.OBJECT_NAME
where user_objects.OBJECT_TYPE='VIEW' AND t1.TABLE_NAME='JW_VJK_KCD_3'
SELECT Column_Name, DATA_TYPE from cols t1 LEFT JOIN user_objects ON t1.table_name = user_objects.OBJECT_NAME
where user_objects.OBJECT_TYPE='VIEW' AND t1.TABLE_NAME='JW_VJK_KCD_3'