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 Query for SSN Format

user7988Mar 27 2008 — edited Mar 28 2008
How to display ssn in this format 123-45-6789 right now it is stored as '123456789' in the database.
I am using 'select nvl(ssn,000000000) from table' to display if ssn field has null values .How can i display as '000-00-0000' format.
Any suggestions
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2008
Added on Mar 27 2008
13 comments
12,513 views