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

Home -> Community -> Mailing Lists -> Oracle-L -> Script to dump data as Insert statements

Script to dump data as Insert statements

From: <nstetson_at_csc.com>
Date: Thu, 18 Jan 2001 14:56:49 -0500
Message-Id: <10745.127067@fatcity.com>


Hi All,

Does anyone have a script to pull data out of a table as insert statements? I'm looking for something generic that will work with all data types. Something that will spool a file of insert statements that can be used to later load the data back in. I have something that spool out to build a sql*loader control file/data file.

Thanks A bunch!
  Nancy Received on Thu Jan 18 2001 - 13:56:49 CST

Original text of this message

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