Skip to Main Content

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!

make abbreviations of long words via sql

amansubhanAug 5 2015 — edited Aug 5 2015

Hello,

I have a situation where i need to abbreviate long module names into abbreviations.

For eg: Utility and Service Management System which should be abbreviated to USMS.

Plus there is a condition, if the module name is not longer more than the specified width of my viewing displaying field, i would like to display the name as it is. Like "Accounts" is not long more than 10 char so its usable

I need a function or script to perform this.

This post has been answered by Karthick2003 on Aug 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2015
Added on Aug 5 2015
8 comments
2,383 views