## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR Start((START)) --> HTMLENCODE[HTMLENCODE]:::quoted HTMLENCODE --> End((END)) ``` ## Purpose The `HTMLENCODE` SQL function returns the input text encoded as HTML, with special characters replaced by their HTML representation. See also [[HTMLDECODE]]. Parameters: - Input (`varchar2`): the input which will be encoded to HTML from text. Returns: A text which is the input encoded as HTML as `varchar2`. ## Examples The following example retrieves the HTML representation of a text: ```sql select htmlencode('Big Spender & Johnson has > output than ACME') ---------------- Big Spender & Johnson has > output than ACME ```