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 -> Re: Using SQL to write SQL...

Re: Using SQL to write SQL...

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Fri, 29 Mar 2002 03:16:07 GMT
Message-ID: <X%Qo8.124855$Yv2.37569@rwcrnsc54>


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

Original text of this message

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