Re: Dynamic SQL

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 25 Apr 2001 22:04:38 -0700
Message-ID: <3AE7AC66.93B9215F@exesolutions.com>

If you need dynamic SQL, and I'm not convinced from your meager explanation that you do, go to the DBMS_SQL package. It was present in version 7 of Oracle as well as in 8.0 and 8.1.

It sounds to me like a cursor would do what you want.

Daniel A. Morgan

Bala S wrote:

> Hello,
>
> How do I create a dynamic insert SQL statement within a dynamic SQL?
> Actually, I don't know how many rows it is going to return. The table I am
> using is user_tab_columns to insert from that into another schema using
> database link.
>
> I cannot use execute_immediate as I need this code to run against oracle 7.x
> and 8.x.
>
> Any help is greatly appreciated.
>
> Thanks
Received on Thu Apr 26 2001 - 00:04:38 CDT