Hi Tomy, Untuk kebutuhan tersebut anda bisa memanfaatkan fungsi Replace atau di 10g ke atas bisa juga pakai Regexp_Replace. Contohnya: vresult varchar2(200); vnewline varchar2(2);
vnewline := chr(13)||chr(10); vresult := replace(vsource,'dan','dan'||vnewline); Cheers, Wadi Achmed On 2/5/2010 1:52 PM, tomy wardana wrote: > sebagai contohbudi dan anton bermain bola > aku ingin sehabis kata dan itu mulcul di baris berikutnya > aku bingung pake fungsi apa? > thank > > > 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] > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > [Non-text portions of this message have been removed]
