SQL Plus - Concat

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