SQL*Plus / PLSQL Formatting

From: Don Miller <dmiller_at_nsf.org>
Date: Fri, 29 Jan 1999 13:06:28 -0800
Message-ID: <36b1f6bf.0_at_news.ic.net>

[Quoted] 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 Received on Fri Jan 29 1999 - 22:06:28 CET