Re: Beating the 255 variable DECODE fn - 8.1.6

In article <93nfmb$nfo$1_at_nnrp1.deja.com>,   josn_at_my-deja.com wrote:
> Hello,
> I am a newbie in PL/SQL and one task I am trying to accomplish
> is "transpose" data in a table to a view for reporting purposes. The
> data is stored in the format
>
> Name Value
> -----------------------
> IssueID 1000
> Assigned to Fred
> .....
> IssueID 1001
> .....
>
> I have successfully managed to use DECODE to transpose it but I am
> running into the 255 variable limit. Does anyone have a possible
> workaround to this apart from splitting the DECODE into 2 views then
> creating a third view to join them?
>
> Thanks,
> -Jos
>
> Sent via Deja.com
> http://www.deja.com/
>

You might want to restate the original problem and what you mean by 'transpose data'. It sounds like a problem that could be solved by a different means. 255 decode statements is quite unusual.

Again, state what the problem is, and your solution.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/