I have to code a where clause in oracle which has the following cases
1. If the input variable is null ignore this column in the where clause
2. if the input variable has value then include this column in the where clause.
ex: select a,b,c
where col_a = input1
and col_b = (if input2 has a value then do the and col_b = input2
else dont )