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

Home -> Community -> Usenet -> c.d.o.misc -> testing input data

testing input data

From: <tobrien_at_reveregroup.com>
Date: Wed, 25 Nov 1998 16:59:42 GMT
Message-ID: <73hd1f$38h$1@nnrp1.dejanews.com>


I need to check to see if data is numeric before allowing it to be processed. What is the best way to test data coming into a pl/sql program? I can't use to_number to convert everything because I have some junk characters coming in. Any suggestions are appreciated...thanx.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 25 1998 - 10:59:42 CST

Original text of this message

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