Home » SQL & PL/SQL » Client Tools » USING THE VALUE & (Oracle 8.1.7, Windows XP)
USING THE VALUE & [message #291824] Mon, 07 January 2008 00:17 Go to next message
kumarvk
Messages: 211
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
Re: USING THE VALUE & [message #291834 is a reply to message #291824] Mon, 07 January 2008 00:36 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

this post similar to your requirement.

check this link


regards,
Re: USING THE VALUE & [message #291849 is a reply to message #291824] Mon, 07 January 2008 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: USING THE VALUE & [message #291860 is a reply to message #291824] Mon, 07 January 2008 01:37 Go to previous message
imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad
Member

set define off
Previous Topic: How to add data with &
Next Topic: Trigger
Goto Forum:
  


Current Time: Mon Dec 05 09:10:28 CST 2016

Total time taken to generate the page: 0.04916 seconds