Substitiution varibles concatenated by backslash

[FrankMUC]

In the command window of PLSQL Dev (V5.0.3 ... V7.0.0

 

[Marco Kalter]

You will first need to execute:

SET ESCAPE OFF

Otherwise the \ will be treated as the escape character. This should be the same in SQL*Plus.

 

[FrankMUC]

Thank you very much for this hint. So only the default settings seem to be different between sql*plus and the command window in plsql-dev.
Regards

 

[Marco Kalter]

Not according to the SQL*Plus documentation:

SET ESCAPE
Defines an escape character you can use before the substitution character. The escape character instructs SQL*Plus to treat the substitution character as an ordinary character rather than as a request for variable substitution. The default escape character is a backslash (\).

Maybe it's a SQL*Plus bug?