Re: dumping a table in sql insert format?

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 Received on Thu May 17 2007 - 14:23:48 CDT