Re: Reloading a table

On 5 Jun 2003 12:44:08 -0700, Michael Kelly wrote:
> I wish to create a .sql file I can run to reload a table. Is there a
> simple way to dump the contents of a table into an sql format file?

Yes
> In other words a series of insert statements.

select 'insert into some_table (col1, col2,...) values (' || col1, ||',' || col1, ||',' ..... || ';' from some_table
/

> please respond to miteke_at_yahoo.com

You post here, you read here so other people can use

    http://groups.google.com/advanced_group_search

    key word(s) here		in the first box
    *oracle*			in the Newsgroup, pick English

You might want to read

    http://www.catb.org/~esr/faqs/smart-questions.html always give info on system and oracle version. Received on Thu Jun 05 2003 - 22:02:41 CEST