umm...coba : set linesize 250; column alamat format a50; select rpad(alamat, 25,' ') alamat from tbl_addr;
regards, pandu wp ________________________________ From: aly rmb <[email protected]> To: [email protected] Sent: Wed, November 4, 2009 12:00:41 PM Subject: Re: [indo-oracle] Create EDI File setelah google kesono kemari, untuk query : select rpad(alamat, 25,' ') from tbl_addr bila di jalankan di SQL*PLUS: satu record menghasilkan banyak row: alamat ------------ --------- --------- ------- JL RAYA SERANG KM 18,8 bagaiman cara query, supaya 1 record menghasilkan 1 row spt : alamat ------------ --------- --------- --------- -- JL RAYA SERANG KM 18,8 sudah di lakukan "set linesize" hasilnya masih banyak rows, kira* querynya spt apa ya? salam/Aly --- On Tue, 3/11/09, aly rmb <aly_...@yahoo. com> wrote: From: aly rmb <aly_...@yahoo. com> Subject: [indo-oracle] Create EDI File To: indo-oracle@ yahoogroups. com Date: Tuesday, 3 November, 2009, 3:09 PM Salam semua, Mohon pencerahannya. ... Ada table namanya : TBL_ADDR isinya : JL.RAYA SERANG KM18,8 table tsb akan kita jadikan Text file, dng menggunakan TEXT_IO.PUT_ LINE yg sudah di test : cursornya menggunakan query : select replace(dump( rpad(alamat, 25,''),17) ,',') from tbl_addr loop-nya linebuf := rpad(nvl(cur. alamat,' '),25, ' ') TEXT_IO.PUT_ LINE(out_ file, linebuf); end loop Intruksi di atas, akan menghasilkan 1 baris tapi komanya akan hilang karena ikut tereplace hasilnya : JL.RAYA SERANG KM188 keterangan : KM188 adalah salah seharusnya KM18,8 kalau cursornya diatas kita ganti select rpad(alamat, 25,' ') from tbl_addr hasilnya ada beberapa baris : JL. RAYA SERANG KM18,8 bagaimana biar text filenya menghasilkan satu baris dan karakternya nga' ada yg hilang ? Terimakasih sebelumnya. salam/Aly New Email names for you! 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] 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]
