About
The Concat system variable sets the character you can use to terminate a substitution variable reference if you wish to immediately follow the variable with a character that SQL*Plus would otherwise interpret as a part of the substitution variable name.
Articles Related
Syntax
SET CON[CAT] {. | c | ON | OFF}
where:
- a period (.) is the default. SQL*Plus resets the value of CONCAT to a period when you switch CONCAT on.
- c is a character
- ON and OFF turns respectively this function ON or OFF
Management
See
show concat
concat "." (hex 2e)
Set
Character
SET concat :
On / Off
SET concat on
SET concat off