Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IS_NUMBER function?

493358Mar 15 2006 — edited Jan 16 2009
I wrote a very primitive function to check if the contents of a VARCHAR field is Numeric. The function simply checks if every character in the field is between 0 - 9.

I feel like this is a very inefficient way to check for numeric/non-numeric data.

Is there a better way to do it?

Comments

2642414

Appreciate your input guys on the above. Thanks.

user7190084

I am considering this product and have the same concerns.  So far I have not found the answer in the documentation.  Please update if you find an answer...I'll do the same.

Thanks

user7190084

FYI..I found this in the Database Firewall Installation Guide for version 5.0:


In the unlikely event that an Oracle Database Firewall should fail, all traffic passes through, ensuring service continuity.


However, I have not found anything in the current Database Vault and Firewall 12c documentation that spells this out.

2642414

It is really disappointing to see such lack of info regarding such an important aspect that might affect business continuity. if the fail open NIC would do the job why it was not explained well and sufficiently in the relevant AVDF 12c Documentation !!?

I will also update here and share if I got some answers.

Still waiting hopefully on useful feedback here by either Oracle guys or people who has done it.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 13 2009
Added on Mar 15 2006
14 comments
187,772 views