Re: formatting numeric values
From: Matt B. <mcb_at_ds.znet.com>
Date: Thu, 18 Jan 2001 20:59:37 -0800
Message-ID: <t6fiu7gj8arjbc_at_corp.supernews.com>
Date: Thu, 18 Jan 2001 20:59:37 -0800
Message-ID: <t6fiu7gj8arjbc_at_corp.supernews.com>
"Myron Wintonyk" <mwintony_at_med.ualberta.ca> wrote in message
news:3A67890C.4ADD0907_at_med.ualberta.ca...
> You can use the to_char funciton. For example, to_char( salary,
> '999999.99' )
> This works in SQL*Plus as well as other query tools such as Golden and
> TOAD.
[Quoted] That will work but since it's now a character for all intents and purposes, it
[Quoted] will be left-justified.
-Matt Received on Fri Jan 19 2001 - 05:59:37 CET