Terimakasih atas responnya P'Pandu. actualnya untuk column alamat = varchar2(200) dan sudah di coba diantaranya set linesize 300 column alamat format a250 masih belum bisa juga :( belum bisa dalam 1 baris ... salam/Aly
--- On Wed, 4/11/09, Pandu W Perwira <[email protected]> wrote: From: Pandu W Perwira <[email protected]> Subject: Re: [indo-oracle] Create EDI File To: [email protected] Date: Wednesday, 4 November, 2009, 1:05 PM umm...coba : set linesize 250; column alamat format a50; select rpad(alamat, 25,' ') alamat from tbl_addr; regards, pandu wp ____________ _________ _________ __ From: aly rmb <aly_...@yahoo. com> To: indo-oracle@ yahoogroups. com 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] 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]
