oracle.rst
changeset 2243 eccc5846e1dd
parent 2231 2813a509381c
child 2244 7d8a914e06ee
--- 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;
+