Kalau tujuannya mau dioutput ke text file bisa pakai cara
set serveroutput on
declare
hasil varchar2(200);
begin
select replace('100ý200ý300ý400ý500','ý',chr(13)||chr(10)) into hasil
from dual;
dbms_output.put_line(hasil);
end;
select replace('100ý200ý300ý400ý500','ý',chr(13)||chr(10)) from dual;
On 5/10/2010 3:30 AM, ETDWI HERU wrote:
>
> kepada mas2 dan mbak2....
> saya mengalami kesulitan menconvert 1 field bernilai
> (100ý200ý300ý400ý500) yang akan saya rubah ke dalam bentuk
> data :
> 100
> 200
> 300
> 400
> 500
> terima kasih atas bantuan mas2 dan mbak2 sebelumnya.... :D
>
> [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.819 / Virus Database: 271.1.1/2864 - Release Date: 05/09/10
> 14:26:00
>
>
[Non-text portions of this message have been removed]
