ia..saya menggunakan 9i :D terimakasih atas penjelasannya....
--- On Tue, 9/15/09, rudi kristanto <[email protected]> wrote: From: rudi kristanto <[email protected]> Subject: Re: [indo-oracle] Minta bantuan Query Level To: [email protected] Date: Tuesday, September 15, 2009, 8:33 PM Pseudo column connect_by_root adalah new feature Oracle 10g. Jadi kalau menggunakan Oracle yang versinya di bawah 10g maka error. Untuk 9i, connect_by_root dapat digantikan dengan sys_connect_ by_path dengan sedikit manipulasi. select jaringan, max(tingkat) jumlah from (select replace(sys_ connect_by_ path(decode( level, 1, idjar),'&'), '&') jaringan, level-1 tingkat from my_table start with konek_ke is null connect by prior idjar = konek_ke ) group by jaringan order by jaringan -- Regards, Rudi Kristanto. ____________ _________ _________ __ From: tri afirianto <bejita_...@yahoo. com> To: indo-oracle@ yahoogroups. com Sent: Wednesday, September 16, 2009 9:46:02 Subject: Re: [indo-oracle] Minta bantuan Query Level saya coba querynya kok tidak jalan ya mas rudi?? yg gagal itu terletak di connect_by_root --- On Tue, 9/15/09, musisi musisi <tc2681_2006@ yahoo.com. sg> wrote: From: musisi musisi <tc2681_2006@ yahoo.com. sg> Subject: Re: [indo-oracle] Minta bantuan Query Level To: indo-oracle@ yahoogroups. com Date: Tuesday, September 15, 2009, 6:41 PM Makasih atas bantuannya pak Rudi --- On Tue, 15/9/09, rudi kristanto <rudiathome@ yahoo. com> wrote: From: rudi kristanto <rudiathome@ yahoo. com> Subject: Re: [indo-oracle] Minta bantuan Query Level To: indo-oracle@ yahoogroups. com Date: Tuesday, 15 September, 2009, 9:34 PM select jaringan, max(tingkat) jumlah from (select connect_by_root idjar jaringan, level-1 tingkat from my_table start with konek_ke is null connect by prior idjar = konek_ke ) group by jaringan order by jaringan -- Regards, Rudi Kristanto. ____________ _________ _________ __ From: musisi musisi <tc2681_2006@ yahoo.com. sg> To: Indo oracle <indo-oracle@ yahoogroups. com>; OCS <oracle-coretech- surabaya@ yahoogroups. com> Sent: Tuesday, September 15, 2009 9:26:34 Subject: [indo-oracle] Minta bantuan Query Level Rekans, saya minta tolong masalah query, saya punya table my_table dengan field dan data sbb: idjar || konek_ke ------------ --------- -- a1 || a2 || a3 || b1 || a1 b2 || a2 c1 || b1 d1 || c1 e1 || d1 saya sudah dapat menampilkan posisi tree sbb : a1 ---> b1 -------> c1 -----------> d1 ------------ -> e1 a2 ----> b2 a3 dengan query sbb: select lpad ( ' ',4*(level+1) ) || idjar as idjar from my_table start with konek_ke is null connect by prior idjar=konek_ ke yang ingin saya tanyakan, query untuk menampilkan data sbb : idjar || jumlah_jar ------------ --------- --- a1 || 4 a2 || 1 a3 || 0 tolong pencerahannya. Thx Get your new Email address! Grab the Email name you've always wanted before someone else does! http://mail. promotions. yahoo.com/ newdomains/ sg/ [Non-text portions of this message have been removed] Get your new Email address! Grab the Email name you've always wanted before someone else does! http://mail. promotions. yahoo.com/ newdomains/ aa/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ____________ _________ _________ _________ _________ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail. yahoo.com [Non-text portions of this message have been removed] New Email addresses available on Yahoo! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail. promotions. yahoo.com/ newdomains/ aa/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
