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!

String formatting

690792May 7 2009 — edited May 7 2009

Hi, everyone.
I need help.

I have a VARCHAR2 type field, and I need to select it with correct formattting.
Format is a template like this '##-##-#####'. It can be different.
e.g. if formatting is '##-##-#####' and field is 'ABCDEFGHI' then query should return
'AB-CD-EFGHI'

What is the best way to do it?

This post has been answered by BluShadow on May 7 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2009

Added on May 7 2009

9 comments

273 views