SQL & PL/SQL

Hi all,

I have lot of conditions in the IF statement.So I wanted to try something new and not sure if there is a possibility for such approach.

Say my IF condition is something like the below(just an example):

IF lv_sal > 1000  AND lv_deptno = 10

THEN

OPEN C1

..

..

lv_sal , lv_deptno ,lv_hiredate  are the procedure parameters

New approach:

lv_query : =        'lv_sal >'

                          ||''''

                          ||'1000'

                          ||''''

                          ||'  AND lv_deptno = '

                          ||''''

                          ||'10'

                          ||'''';

IF || lv_query

THEN

OPEN C1

..

..

when I tried IF || lv_query it errors

Is there any such approach ?

Thanks,

Veronica