coba dengan cara ini select to_char(trunc(12123.345,2),'99,999.99') from dual; hasilnya TO_CHAR(TR ---------- 12,123.34
regards nine --- In [email protected], Herman <[EMAIL PROTECTED]> wrote: > > DH, > > Maaf sebelumnya kalau terlalu simple pertanyaannya :P > > select to_char(12123.345,'999,999.99') from dual ; > select to_char(12123.3,'999,999.99') from dual ; > select to_char(12123,'999,999.99') from dual ; > > Kalau mau outputnya 12,123.34 , 12,123.3 dan 12,123 format stringnya > seperti apa yah ? > > atau ada function lain ? > > Thanks sebelumnya > > -- > - chiank - > > If You can dream it, You can reach it > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
