508 

   509 Move data across DBes

   510 =====================

   511 

   512 Format ``select`` data as ``insert`` statements with ``/*insert*/`` hind (use ``F5`` key in Oracle

   513 developer)::

   514 

   515   select /*insert*/ * from tbl;

   516 

   517 Another useful hint::

   518 

   519   select /*csv*/ * from tbl;

   520 

   521 Alternatively enable output as ``insert`` statments (use ``F5`` key in Oracle developer)::

   522 

   523   set sqlformat insert;

   524   select * from tbl;

   525 

   526   spool /home/user/insert.sql;

   527   select * from tbl where ...;

   528   spool off;

   529