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: dumping a table in sql insert format?

Re: dumping a table in sql insert format?

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Thu, 17 May 2007 19:11:20 GMT
Message-ID: <sN13i.34202$Xh3.20132@edtnps90>


"Mark Harrison" <mh_at_opixar.com> wrote in message news:sn13i.663$C96.334_at_newssvr23.news.prodigy.net...
> What's the best way to dump some tables into a file
> such that the data is in a series of insert statements?
>
> I would like to set up some regression tests for my
> database, and this is the seed data that is needed
> after the schema has been created.
>
> TIA!
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios

A tool like InfoMaker can do that automatically. It's one of the options when saving data.
It shouldn'tbe difficult to write a little pl/sql block using some dynamic sql to generate a text file with all the insert statements.

-- 
Terry Dykstra 
Received on Thu May 17 2007 - 14:11:20 CDT

Original text of this message

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