Question: can we use nvl in where clause?
Answer: in where clause, you can use functions such as substring, etc. as I know nvl is not working in where clause.