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]
>
