Home » SQL & PL/SQL » SQL & PL/SQL » Test for Numeric Function
Test for Numeric Function [message #36574] Wed, 05 December 2001 04:52 Go to next message
kriser
Messages: 11
Registered: October 2001
Junior Member
ORAFAQ
I was wondering if anyone knows of a function in ORACLE that is the same or similar to IsNumeric in VB?

I have amounts being read into my PL/SQL program that I need to test for numeric before inserting them into the table.

Thanks
Kyle

----------------------------------------------------------------------

Report message to a moderator

Re: Test for Numeric Function [message #36575 is a reply to message #36574] Wed, 05 December 2001 05:27 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use to_number, if it is not numeric it will raise exception

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: why make_ref cannot be referenced from a pl/sql procedure
Next Topic: ref cursosr
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 04:48:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.