Hi Team,
I have requirement to use like IF-ELSE logic in SQL.
My Query is like below
SELECT
Req_Type.Seq
, Req_Type.Su_Seq
, Req_Type.ID
, Req_Type.Hold_Until_DT
FROM
SA_Request_Types Req_Type
WHERE
Pending_YN = 'Y'
AND
DECODE (IN_Country_ID, 'ZA',
DECODE (Req_Type.ID, 'CCLULK', Hold_Until_DT,
'CLLULK', Hold_Until_DT,
Hold_Until_DT - 1),
Hold_Until_DT) < SYSDATE
IN_Country_ID is Input Parameter if ZA then do the process. Now i want if
IN_Country_ID='ZA' THEN
DECODE (IN_Country_ID, 'ZA',
DECODE (Req_Type.ID, 'CCLULK', Hold_Until_DT,
'CLLULK', Hold_Until_DT,
Hold_Until_DT - 1),
Hold_Until_DT) < SYSDATE
ELSE
DECODE (IN_Country_ID, 'ZA',
DECODE (Req_Type.ID, 'CCLULK', Hold_Until_DT,
'CLLULK', Hold_Until_DT,
Hold_Until_DT),
Hold_Until_DT) < SYSDATE