HI All, I have a requirement to fetch all records from a table, when the passed parameter is "NULL" in oracle query. Ex- Query -select * from table1 where date=p_date and flag=p_flag Now while fetching data, if I give p_flag as 'Y'- then I'm getting all records where flag=Y. If I give p_flag='N'- then I'm getting all the records when flag=N. But there are few records where flag=(null) in the table. When I give p_flag as NULL- I'm getting the records where flag = Y and N. But I'm not getting the records where flag =(null) But my requirement is- when I give p_flag=NULL, then I want all the records where flag=Y, N, NULL. How to achieve this?...Please help asap. Any help will be greatly appreciated. Thankyou.