Home » SQL & PL/SQL » SQL & PL/SQL » Query Output Question (Oracle 9I)
Query Output Question [message #323217] Tue, 27 May 2008 15:48 Go to next message
leachpau
Messages: 1
Registered: May 2008
Location: Sioux City, IA
Junior Member
Can you tell me if this is possible?

query
select distinct T5.BSTKD, T2.VGBEL
from SAPR3.VBKD T5, SAPR3.LIPS T2
where T2.VGBEL = T5.VBELN and T2.MANDT='900' and T5.MANDT='900'
order by T5.BSTKD asc

What I want is when the field t5.bstkd starts with the letters He, I do not want to show the data in field t2.vgbel (or show some dummy data or something, just not the number contained in t2.vgbel).

example - the above query would return this.

BSTKD VGBEL

Hello 0000044444
Later 0000005661

This is what I would like to see - If BSTKD like He

BSTKD VGBEL
Hello xxxxxxxxxxx or blank
Later 0000005661

Thanks
Re: Query Output Question [message #323218 is a reply to message #323217] Tue, 27 May 2008 15:50 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: Query Output Question [message #323228 is a reply to message #323218] Tue, 27 May 2008 18:10 Go to previous message
harrysmall3
Messages: 109
Registered: April 2008
Location: Massachusetts
Senior Member
And after that - then read up on the DECODE statement Smile
Previous Topic: I have problem with creation for View !!!
Next Topic: OUTERJOIN
Goto Forum:
  


Current Time: Sat Dec 10 22:39:56 CST 2016

Total time taken to generate the page: 0.09096 seconds