Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Help

SQL Help

From: Paul <vmayada_at_ibm.net>
Date: Mon, 5 Jul 1999 19:16:52 +0100
Message-ID: <37813b9e@news1.us.ibm.net>


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 Mon Jul 05 1999 - 13:16:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US