formatting numeric values
From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Fri, 19 Jan 2001 16:39:35 -0000
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740D4133C9_at_apps.lynx-fsc.co.uk>
Date: Fri, 19 Jan 2001 16:39:35 -0000
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740D4133C9_at_apps.lynx-fsc.co.uk>
Hi Matt,
I use TO_CHAR(x, '999,999,99.99') is various scripts and they still display right aligned in TOAD for me.
Norman.
Norman Dunbar EMail: NDunbar_at_LynxFinancialSystems.co.uk Database/Unix administrator Phone: 0113 289 6265 Lynx Financial Systems Ltd. Fax: 0113 201 7265 URL: http://www.LynxFinancialSystems.com ------------------------------------------------------------------------
-----Original Message-----
From: Matt B. [mailto:mcb_at_ds.znet.com]
Posted At: Friday, January 19, 2001 5:00 AM
Posted To: tools
Conversation: formatting numeric values
Subject: Re: formatting numeric values
>> That will work but since it's now a character for all intents and
purposes, it
>> will be left-justified.
-Matt Received on Fri Jan 19 2001 - 17:39:35 CET