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!

Regular Expression Abbreviation of Words

Ankur RainaSep 24 2013 — edited Sep 24 2013

Suppose I have got data in my column like

Balla Ram Chog Mal College

Maharishi Dayanand University

Cambridge Public School

Now I want to write a query using regular expressions to find out the abbreviations. e.g the resulting data set should be:

BRCMC

MDU

CPS

How should I write regexp for it ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2013

Added on Sep 24 2013

#query, #select

21 comments

2,592 views