On Dec 3, 2:14 pm, Ed Prochak <edproc..._at_gmail.com> wrote:
> On Dec 3, 1:58 pm, kishjeff <kishjj..._at_charter.net> 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.
>
> look up the CASE clause
> Ed- Hide quoted text -
>
> - Show quoted text -
thanks to both of you. Decode looks like it works.. let me check out
the case clause now to see which has a better fit.
regards
Jeff
Received on Mon Dec 03 2007 - 13:32:50 CST
