Home » SQL & PL/SQL » SQL & PL/SQL » decoce of two columns
decoce of two columns [message #249976] Fri, 06 July 2007 11:55 Go to next message
vamcs
Messages: 20
Registered: June 2007
Location: somerset
Junior Member

select decode(c1,1,c2='data1',23,c2='data2') from T;
where c1 and c2 columns in tanle t
is this information is sufficient?
Thanks
Re: decoce of two columns [message #249978 is a reply to message #249976] Fri, 06 July 2007 12:00 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use case or decode in decode.
decode(c1,1,decode(c2,'data1',23,'data2'...

Regards
Michel
Previous Topic: extract from a table the 5 highest totals based upon a category
Next Topic: display data based on certain criteria
Goto Forum:
  


Current Time: Sat Dec 10 12:53:48 CST 2016

Total time taken to generate the page: 0.15435 seconds