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: Is Number function?

Re: Is Number function?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 26 Apr 2001 23:23:11 -0700
Message-ID: <3AE9104F.E739685E@exesolutions.com> 






Zeyad S wrote:



> Guys,

> Is there any way in Oracle to check if the value that is entered into a

> character variable is number or not? I have checked Oracle manual and

> seems there is no builtin function to do that.

> Thanks




You didn't look very hard.



Just put TO_NUMBER() into a PL/SQL block and trap the exception if it
fails.



Daniel A. Morgan
Received on Fri Apr 27 2001 - 01:23:11 CDT












Original text of this message













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