Re: SQL Help

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 06 Jul 1999 07:44:05 -0400
Message-ID: <3781EC04.9B6F1776@Unforgettable.com>

Use DBMS_SQL.

Ken

Paul wrote:

> I'm running Oracle 8.
>
> I wish to execute an SQL command that is stored in a table in PL/SQL.
>
> So, for example, take a table called COMMANDS
>
> COMMANDS
>
> Command Other Data....
> select * from TABLE ....
>
> The SQL command "select * from TABLE" is stored in the column Command. I
> want to retrieve this command and execute it.
>
> Can I do the whole thing in PL/SQL?
>
> Thanks
>
> Paul
Received on Tue Jul 06 1999 - 06:44:05 CDT