Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using SQL to write SQL...
use execute meditate
"Ryan Gaffuri" <rkg100_at_erols.com> wrote in message
news:a80hfj$d1b$1_at_bob.news.rcn.net...
> I know I can create a SQL query to generate more sql code for me. Then
spool
> that to a file and execute the file or just copy and paste it and run it
> from SQLPlus.
>
> Is there a way to do all of this in pl/sql and store it in the database?
Ive
> been trying to figure out how to do it. Can I create a cursor... to build
my
> sql statements.. store it in a record and execute it somehow?
>
>
Received on Thu Mar 28 2002 - 21:16:07 CST