Home » SQL & PL/SQL » SQL & PL/SQL » how to use wildcard character & (oracle 8i)
how to use wildcard character & [message #315972] Wed, 23 April 2008 06:46 Go to next message
melvinRav
Messages: 43
Registered: April 2008
Location: India
Member
Hello ppl

i have query

select * 
from 
masterdata 
where 
isg_code in ('ABD','ACX','J&J');


masterdata is the table name
isg_code is item sub group

but when i try to run the code the oracle consider J as a substitution variables
and ask me to put a substitution

Is there way to select J&J




Re: how to use wildcard character & [message #315976 is a reply to message #315972] Wed, 23 April 2008 06:52 Go to previous messageGo to next message
imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad
Member

run this command

set define off;



Re: how to use wildcard character & [message #315977 is a reply to message #315972] Wed, 23 April 2008 06:53 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SQL> SET DEFINE OFF
Previous Topic: multiple values in a field
Next Topic: insert a new column in specific position
Goto Forum:
  


Current Time: Wed Dec 07 03:04:06 CST 2016

Total time taken to generate the page: 0.08530 seconds