oracle.rst
changeset 2280 9ffe47dfa862
parent 2278 954eb979bb4d
child 2340 fc5d1153f3df
--- a/oracle.rst	Wed Oct 24 23:24:34 2018 +0300
+++ b/oracle.rst	Thu Oct 25 17:55:27 2018 +0300
@@ -590,8 +590,18 @@
   select * from tbl where ...;
   spool off;
 
+Another ``sqlformat``::
+
+  set sqlformat default;
+  set sqlformat csv;
+  set sqlformat html;
+  set sqlformat xml;
+  set sqlformat json;
+
 https://dba.stackexchange.com/questions/173540/generate-insert-statements-for-each-entry-in-a-table
   Generate ``insert`` statements for each entry in a table.
+https://oracle-base.com/articles/misc/sqlcl-format-query-results-with-the-set-sqlformat-command
+  SQLcl : Format Query Results with the SET SQLFORMAT Command.
 
 Unlock expired password
 =======================