## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR Start((START)) --> QUOTE_IDENT[QUOTE_IDENT]:::quoted QUOTE_IDENT --> End((END)) ``` ## Purpose The `QUOTE_IDENT` SQL function quotes a text for use as an identifier within an SQL query. Double quotes are added when the text contains upper case or non-alphanumeric characters; otherwise the text is returned unchanged. See also [[QUOTE_LITERAL]] and [[QUOTE_NULLABLE]]. Parameters: - Identifier (`varchar2`): the text to quote. Returns: the quoted identifier as `varchar2`. Returns `null` when the input is `null` or empty. ## Examples The following example quotes `abc`; no quotes are needed: ```sql select quote_ident('abc') ------------------- abc ``` The following example quotes `A`; quotes are added since the text contains an upper case character: ```sql select quote_ident('A') ------------------- "A" ``` The following example quotes a text with spaces: ```sql select quote_ident('select * from dummy_string') ---------------------------- "select * from dummy_string" ```