Very Urgent query Help Needed

[urchin556]

Hi Guys,
I need a urgent solution for a problem.I am
using the following query

select ename from emp where deptno =10

Now I will declare a bind variable and if user passes 'A'
then the query will run as it is and if he passes B
then it should run the above query with this additional clause -> birthdate - hiredate >15.
Please can any one help its very urgent

 

[SantaMufasa]

Urchin,

Try this:

select ename from emp where deptno =10
and (:bind_var = 'A' or 
    (:bind_var = 'B' and (birthdate - hiredate >15)));

Let us know if this resolves your need.

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:55 (02Oct04) UTC (aka "GMT" and "Zulu"), 10:55 (02Oct04) Mountain Time)