Re: dumping a table in sql insert format?

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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org