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*/ * FROM EMPLOYEES; — Tagged XML

The following example shows the output generated by the first statement (SELECT /*csv*/ * FROM EMPLOYEES;):