MARKUP HTML
MARK[UP] HTML [ON | OFF] 
  [HEAD text] 
  [BODY text] 
  [ENTMAP {ON | OFF}] 
  [SPOOL {ON | OFF}]
  [PRE[FORMAT] {ON | OFF}]

Controls whether SQL*Plus will generate HTML output. This command is available starting with SQL*Plus 8.1.6.

Keywords

ON

Specifies that HTML output be generated using the specified options.

OFF

Specifies that HTML output not be generated. This option is the default.

HEAD

Specifies that the text be used as content for the <HEAD> tag. Heading text must be enclosed within quotes. By default, text is `<TITLE>SQL*Plus Report</TITLE>'.

BODY

Specifies that text be used as content for the <BODY> tag. Body text must be enclosed within quotes.

ENTMAP ON

Specifies that SQL*Plus display the special characters "<", ">", and "&" as the HTML entities &lt;, &gt; and &amp;, respectively.

ENTMAP OFF

Specifies that SQL*Plus not change display of the special characters "<", ">", and "&".

SPOOL ON

Specifies that SQL*Plus write HTML tags to the start and end of each file created by the SQL*Plus SPOOL command.

SPOOL OFF

Specifies that SQL*Plus not write HTML tags to the start and end of each file created by the SQL*Plus SPOOL command.

PREFORMAT ON

Specifies that SQL*Plus write output inside the HTML <PRE> tag.

PREFORMAT OFF

Specifies that SQL*Plus not write output inside the HTML <PRE> tag.

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial