Hi All, I am facing challenge in writing where clause. Requirement: Based on parameter value from procedure , where clause condition needs to be build. for eg. let say we have to get status of concurrent program . Here p_status is parameter. if p_status := 'WARNING' then where clause should have condition status_code = 'G' if p_status:='ERROR' then where clause should have condition status_code= 'E' if p_status:='ALL' then where clause should have condition status_code IN ('G','E') I have tried using CASE statement in where clause but it is not working with IN clause. Can someone pls help me writing logic as per above requirement. Thanks in Advance.