Oracle package HTF (for Hypertext functions)

Functions

`address`
`anchor`
`anchor2`
`appletopen`
`area`
`base`
`basefont`
`bgsound`
`big`
`blockquoteopen`
`bodyopen`
`bold`
`br`
`center`
`cite`
`code`
`comment`
`dfn`
`div`
`dlistdef`
`dlistopen`
`dlistterm`
`em`
`emphasis`
`escape_sc`
`escape_url`	Depracted, consider `utl_url`.
`fontopen`
`format_cell`
`formcheckbox`
`formfile`
`formhidden`
`formimage`
`formopen`
`formpassword`
`formradio`
`formreset`
`formselectopen`
`formselectoption`
`formsubmit`
`formtext`
`formtextarea`
`formtextarea2`
`formtextareaopen`
`formtextareaopen2`
`frame`
`framesetopen`
`header`
`hr`
`htitle`
`img`
`img2`
`isindex`
`italic`
`kbd`
`keyboard`
`line`
`linkrel`
`linkrev`
`listheader`
`listitem`
`mailto`
`mapopen`
`meta`
`nextid`
`nl`
`nobr`
`olistopen`
`paragraph`
`param`
`plaintext`
`preopen`
`s`
`sample`
`script`
`small`
`strike`
`strong`
`style`
`sub`
`sup`
`tablecaption`
`tabledata`
`tableheader`
`tableopen`
`tablerowopen`
`teletype`
`title`
`ulistopen`
`underline`
`variable`

ESCAPE_SC

Escape <, >, & and ".

set define off
select
  htf.escape_sc
  (
    '<foo>bar & baz / bar''n "baz"</foo>'
  )
  from dual;
--
-- &lt;foo&gt;bar &amp; baz / bar'n &quot;baz&quot;&lt;/foo&gt;
--

Github repository Oracle-Patterns, path: /Installed/htf/escape_sc.sql

See also utl_i18n.unescape_reference and dbms_xmlgen.convert.

Create a simple HTML document

@spool simple-html-document.html

declare
  procedure o(h varchar2) is -- {
  begin
    dbms_output.put_line(h);
  end o; -- }
begin

  o(htf.htmlopen);

  o(htf.  headopen);
  o(htf.    title('Simple HTML Document'));
  o(htf.  headclose);

  o(htf.  bodyopen);
  o(htf.    header(1, 'Hello World'));
  o(htf.    para);
  o(       'The number is: 42');
  o(htf.    para);
  o(       'New paragraph');
  o(htf.  bodyclose);

  o(htf.htmlclose);

end;
/

@spool_off

Github repository Oracle-Patterns, path: /Installed/htf/create-simple-html-document.sql