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'