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

Using SQL to write SQL...

From: Ryan Gaffuri <rkg100_at_erols.com>
Date: Thu, 28 Mar 2002 20:53:26 -0400
Message-ID: <a80hfj$d1b$1@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 - 18:53:26 CST












Original text of this message













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