Re: SQL Help

From: Michael Ho <infoage_at_hk.super.net>
Date: Sat, 10 Jul 1999 23:10:11 +0800
Message-ID: <37876253.DADB765B@hk.super.net>

User Oracle dynamic SQL utility.

DBMS_SQL if 7.3 or 8.0
EXECUTE IMMEDIATE if 8.1 (8i)

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 Sat Jul 10 1999 - 10:10:11 CDT