What is the easiest way to 'dump' a temp-table into SQL format

[Bill]

Version: 10.2b

So lets say I have a table dogs in progress:

table: dogs
fields: name, age, breed


I want to load them into oracle database using the standard load utility. But the table in oracle looks like this

table: dog
fields: name, age, date_last_updated


so if i make a temp-table matching this, is there a way to 'dump' the temp table into sql? (so that i can load it into oracle)

If not, that is a fine answer too.

Thanks for any help!!

EDIT: By 'sql dump' I mean:

INSERT INTO dog
VALUES (Max, 5, Feb 18, 2013)


is there any way to get the table in this format other then exporting the words "INSERT INTO" into my file.

Continue reading...