Re: Dynamic SQL Query

From: John Russell <netnews6_at_johnrussell.mailshell.com>
Date: Tue, 19 Aug 2003 17:41:27 GMT
Message-ID: <t2o4kvkt7mglpmgi595a78b4ilkp6fbqcd@4ax.com>

On 19 Aug 2003 08:34:45 -0700, j.jones_at_link-hrsystems.com (Jamie Jones) wrote:

>I am having a few problems trying to execute dynamic SQL queries.
>Does anybody have any idea
>how I can get this query working using a SELECT statement that is
>built up dynamically?

This is done through the OPEN-FOR-USING statement rather than EXECUTE IMMEDIATE: http://download-east.oracle.com/docs/cd/B10501_01/appdev.920/a96624/13_elems35.htm#35316

John

--
Photo gallery: http://www.pbase.com/john_russell/

Received on Tue Aug 19 2003 - 12:41:27 CDT