官术网_书友最值得收藏!

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

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;):

主站蜘蛛池模板: 建水县| 麻阳| 盐边县| 博爱县| 武汉市| 方城县| 忻城县| 类乌齐县| 平潭县| 德阳市| 文水县| 凉城县| 博湖县| 丰原市| 阜新市| 益阳市| 满城县| 利辛县| 新建县| 仙居县| 永州市| 白银市| 濮阳市| 宁陕县| 镇康县| 嘉兴市| 屯门区| 兰溪市| 体育| 忻城县| 罗田县| 延吉市| 札达县| 长宁区| 富川| 杭锦后旗| 南溪县| 巴彦县| 泉州市| 玉林市| 蒙城县|