You can use special SQL Worksheet "hints" to generate output in several formats, such as CSV and SQL INSERT statements. (These hints do not work in SQL*Plus but do work in SQLcli.) You must use Run Script (F5), not Execute Statement, to see the formatted output. The hints must be in lowercase. Some example statements showing the available special SQL Worksheet hints are as follows:
SELECT /*ansiconsole*/ * FROM EMPLOYEES; — Best appearance for ANSI terminal.
SELECT /*csv*/ * FROM EMPLOYEES; — Comma-separated values
SELECT /*delimited*/ * FROM EMPLOYEES; — (Same as csv)
SELECT /*fixed*/ * FROM EMPLOYEES; — Fixed-width fields with trailing blanks
SELECT /*html*/ * FROM EMPLOYEES; — Marked-up HTML table
SELECT /*insert*/ * FROM EMPLOYEES; — SQL INSERT statements
SELECT /*json*/ * FROM EMPLOYEES; — JSON object format
SELECT /*loader*/ * FROM EMPLOYEES; — Pipe-delimited format for SQL*Loader
SELECT /*text*/ * FROM EMPLOYEES; — Plain text
SELECT /*xml...