Oracle SQL Developer

SQL Worksheet "hints" for formatting output

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 ...