oke...thanks inijoey... --- On Mon, 4/26/10, inijoey <[email protected]> wrote:
From: inijoey <[email protected]> Subject: Re: [indo-oracle] gabung field varchar dan number To: [email protected] Date: Monday, April 26, 2010, 11:46 AM Kalau masalah space, oracle sudah nyediain fungsi trim, ltrim & rtrim. Silakan dicoba sesuai kebutuhan. regards, joey On 4/26/2010 11:41 AM, david wahyudi wrote: > > mas...mbak semua, > gimana sih cara gabungin field varchar dan number biar hasilnya gak > ada spasinya?? > sql saya seperti ini : > > select kode||tochar( id,'000000' )||'-'||tochar( urut_masuk, '000000') > from buku > > hasilnya sepert ini: > > XXX01 000001- 000001 > > biar hasilnya spt ini XXX01000001- 000001 tanpa spasi gimana??? > > [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]
