SQLcl : Format Query Results with the SET SQLFORMAT Command.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 25 Oct 2018 17:55:27 +0300
changeset 2280 9ffe47dfa862
parent 2279 8c9e8c734f98
child 2281 fdaa046f19ba
SQLcl : Format Query Results with the SET SQLFORMAT Command.
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
 =======================