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!

i want include a hyphen for every 4 digits

SIVASANKAR.SOct 5 2006 — edited Oct 5 2006

hi,

is it possible to include a hyphen inbetween for every 4 digits
4564872030144978

i want output like this
4564-8720-3014-4978

please let me know if it is possible or not
if possible how?

thanks in advance
sivasankar.s
4564872030144978

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2006

Added on Oct 5 2006

9 comments

1,180 views