SQL & PL/SQL

Hi All,

I am passing lv_query to one of the procedures.

It works without adding the condition AND sal IS NOT NULL.

But, when I add it throws the error 'ORA-00908: missing NULL keyword' while parsing query

----piece of code

lv_query := 'select empno,ename from emp

             where ename = '

             ||''''

             ||'SMITH'

             ||''''

             ||'AND sal IS NOT NULL';

Can anyone please suggest the correct way to use IS NOT NULL.

This is just an example.

Thanks,

veronica