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!

Phone number validation using regular expression

247890Oct 26 2006 — edited Oct 27 2006
Hi, could some one help me with validation of phone numbers using regular expressions? I am new to this.

after removing all non-alpha-numeric characters, phone number must be atleast 10 chars long. first 10 or 11 chars must be digits.

if 10 digits long, first digit can't be a zero.
if 11 digits long, first digit must be '1'

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2006
Added on Oct 26 2006
7 comments
9,801 views