# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1540479327 -10800
# Node ID 9ffe47dfa862901a472ef82fc5d32a4ebd45e1ec
# Parent  8c9e8c734f98a98ab29dc3b6e969650489a1a918
SQLcl : Format Query Results with the SET SQLFORMAT Command.

diff -r 8c9e8c734f98 -r 9ffe47dfa862 oracle.rst
--- 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
 =======================