# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1522945353 -10800
# Node ID eccc5846e1ddc2a161cefb821d7f38d980550935
# Parent  1921c2a985c944bb83243e5b5e77964568f069c5
Move data across DBes.

diff -r 1921c2a985c9 -r eccc5846e1dd oracle.rst
--- 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;
+