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!

SQL phone number format check

504552Aug 16 2010 — edited Aug 16 2010
Hello, I am looking for a programmatic way to check phone number formats in my database using SQL. The phone numbers MUST be one of 2 formats:

XXX-XXX-XXXX or (XXX)XXX-XXXX

I want to return the row if they are NOT one of these formats.

Thank you!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2010
Added on Aug 16 2010
6 comments
7,021 views