fitzjarrell_at_cox.net wrote:
> On May 17, 2:19 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> Mark Harrison wrote:
>>> 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
>> SELECT 'INSERT INTO t VALUES (' || srvr_id || ')' FROM servers;
>>
>> Wouldn't external tables be easier?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> Or SQL*Loader, although you probably have enough 'horsepower' at Pixar
> Studios to use external files.
>
>
> David Fitzjarrell
External loader will load 'em. It won't write out loadable files.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu May 17 2007 - 20:22:21 CDT
