Re: Help with select statement (pivot table?)

From: <ak_tiredofspam_at_yahoo.com>
Date: 2 May 2005 10:57:45 -0700
Message-ID: <1115056665.416000.86410@l41g2000cwc.googlegroups.com>

create table a(n number, n1 number, n2 number) Table created

insert into a values(1, 11, 12)
1 row inserted

insert into a values(2, 21, 22)
1 row inserted

select n, k,
case when k=1 then n1 else n2 end n_pivoted from a,
(select 1 k from dual union all select 2 k from dual)

         N K N_PIVOTED
---------- ---------- ----------

         1          1         11
         2          1         21
         1          2         12
         2          2         22

4 rows selected    

drop table a
Table dropped  

HIH Received on Mon May 02 2005 - 12:57:45 CDT