SQLcl : Format Query Results with the SET SQLFORMAT Command.
--- 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
=======================