How to generate a insert file?
Has anyone out there has some kind of software that will export all
the data
from tables in a schema using insert statements and save it as an sql
file
for each table
ie. insert into table_name values ( all the data)
insert into table_name values ( all the data)
Ans:
try TOAD !!
Database -> Object Browser -> Tables / Data, do a sort or filter if
you
want, and then click the button for export data to either clipboard
or
file.
Flo Schmitt