| CONCAT |
CON[CAT] c | ON | OFF |
Sets the character used to terminate a substitution variable reference.
Keywords
c
Specifies a character to terminate a substitution variable reference, if you wish to immediately follow the variable reference with a character that SQL*Plus would otherwise interpret as a part of the substitution variable name. The default is a period.
ON
Resets the value of CONCAT to a period.
OFF
Specifies that no CONCAT character be set.
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.
