Di oracle 11g ada build in function baru, UNPIVOTbarusan di check ini bisa:
create table test1 as select 'Rina' as Nama, 60 as UkuranR, 60 as UkuranL from sys.dual; commit; select nama,decode(RL,'UKURANR','R','L') as RL, Ukuran FROM test1 UNPIVOT INCLUDE NULLS (Ukuran FOR RL IN (UkuranR, UkuranL)); hasilnya: NAMA RL UKURAN ---- -- ---------- Rina R 60 Rina L 60 2 rows selected. tapi kalo dijalanin di 10g, ORA-00933: SQL command not properly ended semoga membantu :) YennM. 2008/10/21 <[EMAIL PROTECTED]> > Dear All.. > > Ada yg bisa bantu SQL untuk Merubah Kolom Menjadi Baris > > Contohnya : > > Nama UkuranR UkuranL > -------- ------------- ------------ > Rina 50 60 > > Menjadi > > Nama RL Ukuran > Rina R 50 > Rina L 60 > > Sebelumnya terimakasih ya atas bantuannya..... > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
