How to export Insert statements

[GeorgeSysarch]

Hello,

Could you help me to find a way to export insert statements from one schema to run in another schema to add rows. I'd like to have the table name fully qualified as well, since we're doing development in "test schema". If everything works, we'll change it to "production schema".

Thanks,
George.

 

[Theod]

Hi,

Tools/Export Tables should do the job.