I have below SQL with bind variables.
UPDATE Table1 SET column1='102.0', column2='12-OCT-1999', column3='AG'
WHERE column4 =:1 and column5 =:2 and column6 =:3 and column7 =:4
AND column8=:5 AND column9=:6 AND NVL(column10,0) <=:7;
When the 3rd and 4th bind variable values are NULL and the actual values in the table are also null it is not updating that record, as there should be "is NULL" over there. Please suggest how I can use bind variables in this case?