B
Bill
Guest
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...
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...