Want to export data from Oracle table to SQL file for upserting?
Using OraLoader, you can export data from Oracle table to sql file for upserting easily and fast, just a few mouse clicks!
Export data from Oracle table to SQL file for upserting
Click “Unload From Table” at task dialog.
then show the Export Single Table form.
1. Select SQL file type.
2. Select table.
3. Enter data file name.
Set “Convert Mode” to “Upsert”, enter “Update Key”.