Re: How to make dynamic SQL in PL/SQL ?
From: Robert Goodwin <robert.goodwin_at_msfc.nasa.gov>
Date: 1995/04/07
Message-ID: <3m3k5r$gj1_at_hammer.msfc.nasa.gov>#1/1
Date: 1995/04/07
Message-ID: <3m3k5r$gj1_at_hammer.msfc.nasa.gov>#1/1
In article <3m3dpa$i9d_at_ccpnws.in2p3.fr>,
chaleat_at_cc.in2p3.fr (Philippe Chaleat) wrote:
>Hello,
>
> I want to create the WHERE clause of a query into a PL/SQL procedure,
>as it can be done in Pro*C. Is it possible ?
>
>
> Thanks...
My understanding is that this is possible as of Oracle7 version 7.1, although I haven't actually tried it. The March/April issue of ORACLE Magazine has an article about this.
:-) Robert
Robert Goodwin | phone: (205)461-4582 Database Development | fax: (205)461-4999 New Technology, Inc. | Huntsville, AL | robert.goodwin_at_msfc.nasa.gov ---------------------------------------------------------------------- "It's a database thing. You wouldn't understand." ----------------------------------------------------------------------Received on Fri Apr 07 1995 - 00:00:00 CEST