Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL question

PL/SQL question

From: Manjula Krishnan <krishnan_at_mailhost.tcs.tulane.edu>
Date: 1997/07/30
Message-ID: <33DF5DB4.1DC2@mailhost.tcs.tulane.edu>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US