SQL Plus - Concat

1 - 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.

3 - 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

4 - Management

4.1 - See


show concat


concat "." (hex 2e)

4.2 - Set

4.2.1 - Character


SET concat :

4.2.2 - On / Off


SET concat on


SET concat off


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap