OraFAQ Forum: Client Tools » USING THE VALUE &

Home » Other » Client Tools » USING THE VALUE & (Oracle 8.1.7, Windows XP)

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

USING THE VALUE & [message #291824]

Mon, 07 January 2008 00:17

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Hi,

I have few records using the value & in the record.

For example like this:

C&E HDT
C&E LDT

When I using the condition like this

select code,desc from MRO where
MAX(decode(code,'BS',cur_mf,'')) "BUS",
MAX(DECODE(CODE,'C&E HDT',cur_mf,'')) "C&E HDT",
MAX(DECODE(CODE,'C&E LDT',cur_mf,'')) "C&E LDT",
MAX(DECODE(CODE,'F MDT',cur_mf,'')) FMDT,
MAX(DECODE(CODE,'N LDT',cur_mf,'')) NLDT,
MAX(DECODE(CODE,'TF PKU',cur_mf,'')) TF_PKUP

When I run this I am not getting the result for C&E HDT and C&E LDT, can anyone help me

Report message to a moderator

Re: USING THE VALUE & [message #291834 is a reply to message #291824]

Mon, 07 January 2008 00:36

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

this post similar to your requirement.

check this link

regards,

Report message to a moderator

Re: USING THE VALUE & [message #291849 is a reply to message #291824]

Mon, 07 January 2008 01:21

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please search BEFORE posting.
There is the same question a couple of days before.
And this has been asked so many times.

Regards
Michel

Report message to a moderator

Re: USING THE VALUE & [message #291860 is a reply to message #291824]

Mon, 07 January 2008 01:37

imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad

Member

set define off

Report message to a moderator

Previous Topic:	How to add data with &
Next Topic:	Trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 09:31:16 CST 2025