OraFAQ Forum: SQL & PL/SQL » how to use wildcard character &

Home » SQL & PL/SQL » SQL & PL/SQL » how to use wildcard character & (oracle 8i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to use wildcard character & [message #315972]

Wed, 23 April 2008 06:46

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

Report message to a moderator

Re: how to use wildcard character & [message #315976 is a reply to message #315972]

Wed, 23 April 2008 06:52

imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad

Member

run this command

set define off;

Report message to a moderator

Re: how to use wildcard character & [message #315977 is a reply to message #315972]

Wed, 23 April 2008 06:53

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SQL> SET DEFINE OFF

Report message to a moderator

Previous Topic:	multiple values in a field
Next Topic:	insert a new column in specific position

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 21:40:06 CST 2024