Forums Active Threads
Print Thread
Substitiution varibles concatenated by backslash
#20833 01/05/06 07:45 PM
Joined: Nov 2003
Posts: 35
F
FrankMUC Offline OP
Member
OP Offline
FrankMUC
Member
F
Joined: Nov 2003
Posts: 35
In the command window of PLSQL Dev (V5.0.3 ... V7.0.0
Re: Substitiution varibles concatenated by backslash
#20834 01/05/06 10:01 PM
Joined: Aug 1999
Posts: 22,220
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,220
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.

Marco Kalter
Allround Automations
Re: Substitiution varibles concatenated by backslash
#20835 01/05/06 10:44 PM
Joined: Nov 2003
Posts: 35
F
FrankMUC Offline OP
Member
OP Offline
FrankMUC
Member
F
Joined: Nov 2003
Posts: 35
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
Re: Substitiution varibles concatenated by backslash
#20836 01/06/06 08:48 PM
Joined: Aug 1999
Posts: 22,220
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,220
Not according to the SQL*Plus documentation:
[quote]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 (\).[/quote]Maybe it's a SQL*Plus bug?

Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.039s Queries: 13 (0.020s) Memory: 2.5070 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-18 06:37:35 UTC
Valid HTML 5 and Valid CSS