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

----------------------------------------------------------------------
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

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


Current Time: Thu May 23 01:17:01 CDT 2024