I have a question about PL/SQL, and also setting up JDeveloper 9.0.3
I know i have been reading the PL/SQL 101 Books From Oracle Press and I purchased the Oracle 8i Web Developent book, However I cannot seem to find how to do a Phone Number for the Project I am Playing with.
Example a 18005551212 I want to do 1 (800) 555-1212 would I have to do a substruct? how do you do a substruct? (It is not in the book)
how does one do that?
Question 2 Since My Setup at home Does not have the power to Run Orale 9ias i am Running Oracle 8.1.7 Rev 3 . Can I Use Jdev 9.0.3 with the JDBC thin Client With the Oracle 8.1.7 Rev 3 Enterprise? If so the how can i do that?
If only Oracle had a mask like Access. Perhaps you could write a function that started from the right and grabbed 4 digits, and then grabbed the next 3 and inserted a hyphon between the two, and then if there are another three digits enclose in () and if there is a 1 place it in the front. You could even add in logic that says if there isn't an area code then it would become the default area code. you can also look into a third party tool to clean up and format the data.
One such tool is made by a company called 1st Logic. I'm sure there are others.