sudah di coba pa, tapi hasilnya sama dengan : select * from baju order by kode_baju;
btw, fungsi dari substr itu apa pa? mohon bimbingannya ... terima kasih .. ________________________________ From: jimmy hikock <[email protected]> To: [email protected] Sent: Tue, December 1, 2009 3:11:48 PM Subject: Re: [indo-oracle] Mx7 - Urutan coba ketik : select * from baju order by substr(kode_ baju,1,1) , kode_baju; --- On Tue, 12/1/09, Mx7 <iqbal_gamers@ yahoo.com> wrote: From: Mx7 <iqbal_gamers@ yahoo.com> Subject: [indo-oracle] Mx7 - Urutan To: indo-oracle@ yahoogroups. com Date: Tuesday, December 1, 2009, 2:19 AM @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]
