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
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?
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: 65137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use case or decode in decode.

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: Thu Aug 17 08:53:53 CDT 2017

Total time taken to generate the page: 0.17823 seconds