I have a script that looks for all jobs that contain a particular calendar.
Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this?
I have tried:
select job_name from job where run_calendar='1&15dom'
select job_name from job where run_calendar='1\&15dom'
Any help is much appreciated...
Linda
Which database is it? MySQL does not seem to have this problem.
mona
3
Are you running this in SQL Plus. & is a substitution variable in Oracle. The only way to prevent substitution in SQL Plus is by setting define off.
Run SET DEFINE OFF before running the SQL command
Thanks!
I did a "set escape \" in sqlplus and then I was able to backslash the literal...