Skip to Main Content

APEX

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!

Format mask for phone numbers

180271Sep 30 2005 — edited Oct 4 2005
What is the trick for using a format mask on a phone number field?
I have tried 999"-"9999 ,FM999-9999 and FM999"-"9999 but it give me an error when the data loads.

phone_number varchar2(7)
phone_number2 number(7)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2005
Added on Sep 30 2005
3 comments
1,276 views