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!

Select query

user7988Jun 27 2008 — edited Jun 27 2008
How to display with zeros if some digits in ssn are empty
for example
-12-1234
111- -2222
111-11-
should be displayed as 000-12-1234
111-00-2222
111-11-0000

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2008
Added on Jun 27 2008
7 comments
2,818 views