I have a VARCHAR2 field named s_phone, and it stores the values using ten digits, with no other characters, as in 3136541234. I want to display that phone number as (313)654-1234. I have indications (from a textbook) that I can use FM"("999")"999"-"9999 somehow, but I can't seem to apply this correctly. For example, I have tried variations like these below to no avail:
SELECT s_phone FM"("999")"999"-"9999
SELECT TO_CHAR (s_phone, 'FM(999)999-9999')
P.S. I'm trying this service for the first time, and now I just saw that I only have 75 points. Well, I'll just have to submit the question and hope for kindness.