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!

Zip code conversation

623795Feb 18 2008 — edited Feb 18 2008

I just came from the SQL2000 shop into Oracle10g. I am trying to format the zip code to read 00000 or 00000-0000 depending on the result set. Any Ideas???

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 17 2008

Added on Feb 18 2008

15 comments

1,742 views