Format mask for phone numbers
180271Sep 30 2005 — edited Oct 4 2005What 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)