Re: return column in select based on another column value

kishjeff wrote:
> Hi.
> This is sort of like asking how to do a comma operator in sql on
> Oracle.
> I'm not sure how to approach asking the question, or even search for
> it except
> for posting the question here.
>
> If I have this table (2 cols, 1st row is col name):
>
> col1 col2
> type1 def5
> type2 abc4
> type1 null
> type3 null
>
> I'd like to have a select statement return this:
>
> colz coly
> null def5 because it is type1 return col2 as 2nd col
> abc4 null because it is type2 return col2 as 1st col
> null null
> null null
>
> in other words I'd like to have a certain column in the result set
> return:
> col2 in coly or col2 in colz based on value of col1
>
> What is the best way to do this with an sql query, or is it even
> possible?
> I'm targeting Oracle 9i onwards
> thanks for even a hint.. I can look up the details.

Making a wild stab at what you are asking use DECODE or CASE http://www.psoug.org/reference/decode_case.html

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org