SQL Plus - Concat

Card Puncher Data Processing


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.


SET CON[CAT] {. | c | ON | OFF}


  • 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



show concat
concat "." (hex 2e)



SET concat :

On / Off

SET concat on
SET concat off

Discover More
Card Puncher Data Processing
SQL Plus - Escape

Escape is a system variable that: defines the character you enter as the escape character. turn the Escape Mode as On or Off See also concat
Card Puncher Data Processing
SQL Plus - Special Characters

Useful command in sqlplus. The At & character is the default character that define a substitution variable. You can change it with the define system variable. The slash command (/): ...

Share this page:
Follow us:
Task Runner