Re: Convert columns to rows

Navin wrote:

> Convert columns to rows
>
> hi,
> I need to convert columns to rows
>
> here i have sample input data
>
> weekno manager1 manager2
> 51 33454 26749
> 52 33454 26749
>
> i wnat the output like this
>
> weekno manager
> 51 33454
> 51 26749
> 52 33454
> 52 26749
>
> colud u please help me out how to go about this and if any query to do so.

Use DECODE. You will find examples of crosstabbing at: http://www.psoug.org/reference/decode_case.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)