changeset 2280:9ffe47dfa862

SQLcl : Format Query Results with the SET SQLFORMAT Command.
author Oleksandr Gavenko <gavenkoa@gmail.com>
date Thu, 25 Oct 2018 17:55:27 +0300
parents 8c9e8c734f98
children fdaa046f19ba
files oracle.rst
diffstat 1 files changed, 10 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- 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
 =======================