Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> decimal precision to string

decimal precision to string

From: jobs <jobs_at_webdos.com>
Date: 7 May 2007 12:52:46 -0700
Message-ID: <1178567566.163340.159930@u30g2000hsc.googlegroups.com> 





new to Oracle.



function output is number and produces things like this



100


19.95


19.0005


.00625


3.1




I need outputs to be reformated to format out into char(5), no decimal
point rounded to hundreth decial.. looking like this?
10000


01995


01900


00001


00310
Received on Mon May 07 2007 - 14:52:46 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US