Skip to Main Content
Forums

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!

How to test a variable to determine whether it is a NUMBER

431901Dec 16 2004 — edited Jan 13 2005
Hello again,

I would like to find out how to test a variable to determine whether it is a NUMBER.

In other words find out if a variable only contains numbers.

Also I would like to know how to test a variable to see if it contains characters - at certain locations.

For instance test A3214 to see if it has an alphabetic character at the location of the first character and whether the rest of the characters are numbers.

Thanks
Douglas McGillivray
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2005
Added on Dec 16 2004
17 comments
3,772 views