Re: Generate SQL on the Fly
From: Adrian Hands <AHands_at_sprynet.com>
Date: Sat, 28 Nov 1998 22:01:15 -0500
Message-ID: <3660B8FB.870007ED_at_sprynet.com>
Date: Sat, 28 Nov 1998 22:01:15 -0500
Message-ID: <3660B8FB.870007ED_at_sprynet.com>
Splezunk wrote:
>
> Hi there,
>
> Is there a way to generate SQL statements on the fly within a PL/SQL
> procedure.
>
> EG. UPDATE ?
> (?,?,?,?)
> VALUES
> (?,?,?,?)
> WHERE ? = ?
> AND ? = ?;
>
> All the '?' marks need to be filled in on the fly. Anybody have any
> ideas?
>
> Thanks
>
> PS. Please CC me a copy of all replies.
See the built-in package DBMS_SQL Received on Sun Nov 29 1998 - 04:01:15 CET