Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: to_number and trailing spaces

Re: to_number and trailing spaces

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 28 Mar 2007 15:19:15 -0700
Message-ID: <1175120355.357987.320500@p15g2000hsd.googlegroups.com> 





On Mar 28, 12:22 pm, "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




Take a look at the pad functions ( lpad and rpad  )... these can be
used to fill in what you need
Received on Wed Mar 28 2007 - 17:19:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US