Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to dump table contents as SQL statements?
Oracle SQL*Plus
Copy function.
copy from <source_username>@<source_alias> -
to <target_username>@<target_alias> -
append <target_table> -
using <query on source database>
Duncan