Re: SQL*Plus / PLSQL Formatting

[Quoted] A copy of this was sent to "Don Miller" <dmiller_at_nsf.org> (if that email address didn't require changing) On Fri, 29 Jan 1999 13:06:28 -0800, you wrote:

>I have a number that is being displayed with TO_CHAR.
>
>TO_CHAR( 0.001 ) = .001
>TO_CHAR( 0.001, '0D9999999999' ) = 0.0010000000
>TO_CHAR( 0.001, '0D0000000000' ) = 0.0010000000
>
>I want the left side of the decimal to at least display a zero; however, I
>want the right side of the decimal to display a floating decimal. Any ideas
>on how I can achieve this?
>
>Don
>dmiller_at_nsf.org
>

[Quoted] something like this:

  1* select rtrim( TO_CHAR( 0.001, '0D9999999999' ), '0' ) from dual SQL> / might be what you want (hard to tell, i don't really know what you mean by a floating decimal on the right side of the decimal...)  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.