Makasih buat bantuannya. Saya sudah coba dan lihat di manual oracle 817.
query ini ga bisa dan menghasilkan pesan: ORA-03113: end-of-file on communication channel ada keterangan lain? Wardi --- On Thu, 6/12/08, chiank <[EMAIL PROTECTED]> wrote: From: chiank <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] Tanya query To: [email protected] Date: Thursday, June 12, 2008, 2:21 AM 2008/6/12 Wardiman Sagala <wardi_sagala@ yahoo.com>: > Teman2 milist, > > Saya mau tanya tentang report matrix. > > query: > > SELECT BT_MCN_NO,BTD_ SUPPLY_TEMP SUPPLY_TEMP, BTD_RETURN_TEMP > > RETURN_TEMP, BTD_TIME > > FROM BOILER_TEMP, BOILER_TEMP_ DETAIL > > WHERE BT_YEAR=BTD_ YEAR > > AND BT_MCN_NO= BTD_MCN_NO > > AND BT_REPORT_NO= BTD_REPORT_NO > > AND BT_DATE=:P_DATE > > yg jadi row: bt_mcn_no > > yg jadi coloumn: btd_time > > yg jadi cell: BTD_SUPPLY_TEMP, BTD_RETURN_TEMP > > data bdt_time: 08, 09, 10, .. 24, 01, 02, 03, 04, 05, 06, 07. > > saat ini report menghasilkan btd_time mulai dari 01 sd 24 (ascending). > > masalahnya gimana supaya tampilan report btd_time (coloumn) dimulai > > dari 08 sd 24, 01,02,03,04, 05,06, 07? > kalau diquerynya ditambahin order by gimana? order by case when btd_time in (01,02,03,04, 05,06, 07) then 1 else 2 end desc maaf ya kalau salah. maklum newbie... :) [Non-text portions of this message have been removed]
