Hello all oracle dba experts,
I am here in search for your lighting knowledge to help me.
I would like ( not sure if possible) to select a column from some table depending on the user input bind variable, like:
select (case :bindvar = -1 then
select columnA
from tableA
where columnB='something';
else
select columnC
from tableB
where columnD = 'otherThing';
end;)
from dual;
Can you help me out with the correct syntax, please?
Thanks
Regards,
Carlos