Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: to_number and trailing spaces
Well, the two links you provided say nothing about to_number not being
designed to return trailing spaces. In fact, one of the links from
the oracle site
http://download-east.oracle.com/docs/cd/B19306_01/olap.102/b14346/dml_x_stddev022.htm#i78653
gives an example showing trailing spaces.
I did find in the documentation the Oracle does not store trailing zeros for NUMBER types, but this is output from a function that uses a format specifier that can specify 9D000.
David
fitzjarrell_at_cox.net wrote:
> On Mar 28, 11:22 am, "dmonder" <dmon..._at_gmail.com> wrote:
> > I am trying to get to_number to return trailing spaces using the
> > format '9D000' but it does not. Can anyone explain to me why this is?
> >
> > David Onder
>
> The to_number() function isn't designed to 'return trailling spaces'.
> Stop expecting it to do so. Please read the documentation on
> to_number():
>
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/functions191.htm
>
> Or choose which document you'd like to read:
>
> http://www.oracle.com/pls/db102/search?remark=quick_search&word=to_number&tab_id=&format=ranked
>
>
>
> David Fitzjarrell
Received on Wed Mar 28 2007 - 12:44:08 CDT