Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: to_number and trailing spaces
On Mar 28, 12:44 pm, "dmonder" <dmon..._at_gmail.com> wrote:
> 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...
>
> 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
>
>
>
> fitzjarr..._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/f...
>
> > Or choose which document you'd like to read:
>
> >http://www.oracle.com/pls/db102/search?remark=quick_search&word=to_nu...
>
> > David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -
That example does not show this returning trailing spaces, it DOES list a space as a valid NLS_NUMERIC_CHARACTER.
David Fitzjarrell Received on Wed Mar 28 2007 - 13:15:54 CDT