akan saya coba SELECT kode_baju FROM BAJU ORDER BY substr(KODE_ BAJU,1,1) desc, KODE_ BAJU asc
coba dech oLa ----- Original Message ----- From: yulius_wibowo To: [email protected] Sent: Wednesday, December 02, 2009 3:44 PM Subject: [indo-oracle] Re: Mx7 - Urutan Sekedar menambahkan: SUBSTR diambil dari kata Sub+String (bagian dari deretan huruf). SUBSTR('Hello SQL',1,5) => Hello SUBSTR('Hello SQL',7,9) => SQL SUBSTR('Hello SQL',7) => SQL Mas Mx7, Kalau anda ingin lihat arti ini itu, coba akses saja ke URL http://tahiti.oracle.com Di situ anda bisa masukkan katakunci yg anda inginkan, dan anda bisa dapatkan penjelasannya secara lebih detail (in English). cmiiw, bw --- In [email protected], Riani Witania <rianiwita...@...> wrote: > > substr tuh fungsi buat ambil karakter dalam suatu string > > Saya tahunya cuman yang ==> substr(KODE_ BAJU,1,1) desc > substr(string,mulaidari,berapabanyak) > kalo substr("Oracle",1,1) = "O" > > > > > > ________________________________ > From: Mx7 <iqbal_gam...@...> > To: [email protected] > Sent: Wed, December 2, 2009 10:30:55 AM > Subject: Re: [indo-oracle] Mx7 - Urutan > > > iya bozz ... berhasil heheheh... thx ... > > btw, bisa tolong dijelaskan maksudnya : > substr(KODE_ BAJU,1,1) desc, --> substr itu apa? terus 1,1 itu apa? > substr(KODE_ BAJU,2)asc; --> 2 itu apa? > > mohon bimbingannya ... > terima kasih banyak ... > > ____________ _________ _________ __ > From: Stefanus Henry Gunawan <shguna...@vianet. ca> > To: indo-oracle@ yahoogroups. com > Sent: Wed, December 2, 2009 9:46:43 AM > Subject: Re: [indo-oracle] Mx7 - Urutan > > Walah permintaannya koq aneh2 ya. > beginikah maksud anda? > > SELECT kode_baju FROM BAJU > ORDER BY > substr(KODE_ BAJU,1,1) desc, > substr(KODE_ BAJU,2)asc > ; > > Select substr(kode_ baju,1,1) Awal > ----- Original Message ----- > From: Mx7 > To: indo-oracle@ yahoogroups. com > Sent: Tuesday, December 01, 2009 9:26 AM > Subject: Re: [indo-oracle] Mx7 - Urutan > > Bukan itu maksudnya mas ... > kalo pake desc hasilnya jadi : > > J-0002 > J-0001 > B-0004 > B-0003 > B-0002 > B-0001 > > sedangkan saya pengennya jadi : > J-0001 > J-0002 > B-0001 > B-0002 > B-0003 > B-0004 > > apakah bisa ? atau memang ngga bisa? > > mohon bimbingannya > terima kasih .. > > ____________ _________ _________ __ > From: Andi Kurniawan <ak.rpl2006@ gmail. com> > To: indo-oracle@ yahoogroups. . com > Sent: Tue, December 1, 2009 3:19:49 PM > Subject: RE: [indo-oracle] Mx7 - Urutan > > Maksudnya pake descending sort ya Mas? > > select * from baju > order by (kode_baju)desc; > > From: indo-oracle@ yahoogroups. com [mailto:indo- oracle@ yahoogroups. com] On > Behalf Of Mx7 > Sent: Tuesday, December 01, 2009 2:20 PM > To: indo-oracle@ yahoogroups. com > Subject: [indo-oracle] Mx7 - Urutan > > @all > > iya thx semuanya .. dah saya coba pake commit agar data2 yang telah di > update, delete, dsb ngga ilang lagi .. > > ada pertanyaan lain soal urutan yang ditampilkan .... > > saya coba ketik : > select * from baju > order by kode_baju; > > KODE_BAJU > ------------ - > B-0001 > B-0002 > B-0003 > B-0004 > J-0001 > J-0002 > > pertanyaannya : > 1. Gimana caranya agar hasilnya urutan yang J dulu, baru yang B... maksudnya > seperti ini : > > KODE_BAJU > ------------ - > J-0001 > J-0002 > B-0001 > B-0002 > B-0003 > B-0004 > > mohon bimbingannya ... > terima kasih banyak ... > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > ------------ --------- --------- --------- --------- --------- - > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 9.0.709 / Virus Database: 270.14.88/2538 - Release Date: 12/01/09 02:59:00 > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
