Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL question
Hi:
I have a question for you ORACLE gurus out there. I want to write a procedure with a dynamic SELECT statement. For eg:
select a, b, c from table
where key1 = inp1
join key1 = inp2;
The join can be either and/or. I am passing inp1, join, inp2 to the procedure from a webform. Ideally I would like to have inp1, inp2, ... inpn with join1....join(n-1).
How can I do this? Please HELP
Thanks,
Manjula Received on Wed Jul 30 1997 - 00:00:00 CDT