Re: PL/SQL question

From: Brad Worsfold <bworsfold_at_vic.lgs.ca>
Date: 1997/08/12
Message-ID: <01bca757$8eef1dc0$0faf22cf@cerulean>#1/1

Check out the DBMS_SQL package in the Application Developers Guide!!!

Manjula Krishnan <krishnan_at_mailhost.tcs.tulane.edu> wrote in article <33DF5DB4.1DC2_at_mailhost.tcs.tulane.edu>...
> 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 Tue Aug 12 1997 - 00:00:00 CDT