I have a case statement here for the defect points.
cursor cur_defect_points IS
SELECT
TRACK_SEGMENT,
TRACK_TYPE,
DEFECT_TYPE_C
case WHEN DEFECT_TYPE_C = POINTS_BB_P THEN v_points end V_POINTS_BB_P ,
case WHEN DEFECT_TYPE_C = POINTS_BHB_P THEN v_points end V_POINTS_BHB_P ,
case WHEN DEFECT_TYPE_C = POINTS_BRO_P THEN v_points end V_POINTS_BRO_P,
FROM OTS_OWN.CSXT_ENG_RAIL_DEFECT2
END CASE ;
FROM OTS_OWN.CSXT_ENG_RAIL_DEFECT2
ORDER BY
TRACK_SEGMENT,
TRACK_TYPE;
I KNOW THAT THE SYNTAX ITSELF SOUNDS WRONG BECAUSE OF THE CASE STATEMENT. 'FROM' SHOULD BE BEFORE THE CASE STATEMENT. hOW DO I DO THIS. HOW TO INCLUDE THE CASE STATEMENT. AND WHAT SHOULD BE THE SYNTAX FOR CASE STATEMENT HERE. THE CURSON IS INSIDE A PROCEDURE. PLEASE ADVICE!!