Question: can we use nvl in where clause in oracle?
Answer: where P_INFO, P_DATE and P_ID are parameters. In the normal case every parameter is NULL. But then the where clause AND msg_id = NVL(P_ID, msg_ID) don't return the rows where msg_id itself is NULL.