& in SQL query

Lindarella · #1 (**permalink**) 10-06-2006

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

cbkihong · #2 (**permalink**) 10-06-2006

Which database is it? MySQL does not seem to have this problem.

mona · #3 (**permalink**) 10-06-2006

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

Lindarella · #4 (**permalink**) 10-09-2006

Thanks!

I did a "set escape \" in sqlplus and then I was able to backslash the literal...

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
sed query	gopsman	Shell Programming and Scripting	4	02-03-2009 02:41 AM
Query in awk	raguramtgr	UNIX for Dummies Questions & Answers	1	08-31-2004 05:38 AM
Query In awk	raguramtgr	UNIX for Dummies Questions & Answers	1	08-27-2004 11:00 AM
RPM Query	silvaman	UNIX for Advanced & Expert Users	1	08-15-2003 07:56 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by