Move data across DBes.
--- a/oracle.rst Wed Mar 14 17:31:26 2018 +0200
+++ b/oracle.rst Thu Apr 05 19:22:33 2018 +0300
@@ -505,3 +505,25 @@
Find time at timezone::
select SYSTIMESTAMP at time zone 'GMT' from dual;
+
+Move data across DBes
+=====================
+
+Format ``select`` data as ``insert`` statements with ``/*insert*/`` hind (use ``F5`` key in Oracle
+developer)::
+
+ select /*insert*/ * from tbl;
+
+Another useful hint::
+
+ select /*csv*/ * from tbl;
+
+Alternatively enable output as ``insert`` statments (use ``F5`` key in Oracle developer)::
+
+ set sqlformat insert;
+ select * from tbl;
+
+ spool /home/user/insert.sql;
+ select * from tbl where ...;
+ spool off;
+