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!

How to remove words which consist of max 2 letters?

534754May 30 2008 — edited May 31 2008
Hi everybody,

Is it possible to remove words from string which consist of max 2 letters using REGEXP_REPLACE?

For example string is 'aa bbb cc dddd' and result should be ' bbb dddd' (3 spaces) or 'bbb dddd' (1 space). It does not matter which one of results.

Or exists another method to achieve this?

Thank you.

Matus.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2008
Added on May 30 2008
6 comments
655 views