Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Return Single Row with Multiple Cols Instead of Multiple Row

Re: Return Single Row with Multiple Cols Instead of Multiple Row

From: Billy <vslabs_at_onwe.co.za>
Date: 26 Oct 2005 01:36:11 -0700
Message-ID: <1130315771.295822.141540@g44g2000cwa.googlegroups.com>


DA Morgan wrote:

> Ah the fragrant smell of homework.

Ah.. Daniel, if only we were still that young... :-)

> Look at using DECODE.

CASE is much nicer and a lot more readable and maintable.. (he says despite still using the DECODE on many an occassion)

--
Billy
Received on Wed Oct 26 2005 - 03:36:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US