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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Looking to dump table into a text file of INSERT statements

Re: Looking to dump table into a text file of INSERT statements

From: BILL M COHEE <COHEEB_at_prodigy.net>
Date: Wed, 12 Aug 1998 00:46:51 -0400
Message-ID: <6qr60k$8guu$1@newssvr04-int.news.prodigy.com> 





A DBA may have a more brute force solution for you, but as a developer I
would recommend using the UTIL_FILE package.  You could open a cursor, fetch
each row,and then output the insert statement for the rows values to a text
file using the package.



Bill in NY



Chris Schoenfeld wrote in message <35D0C9EB.98D3E728_at_ixlabs.com>...
What is the easiest way to do this in Oracle?



Chris



Received on Tue Aug 11 1998 - 23:46:51 CDT












Original text of this message













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