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!

To get Length of each word in a String.

546215Nov 15 2006 — edited Nov 16 2006

Hi,

I wanted to know, how to calculate the length of each word in a string.Suppose for example if the input is like this:

i/p:'Tech on the Net'

o/p:4 2 3 3

ie Tech-4 on-2 the-3 Net-3

another Ex:i am a good boy
o/p:1 2 1 4 3

Kindly let me know any PL/SQL function or SQL query which would help to achieve this.

Thanks&Regards
Zaheer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2006

Added on Nov 15 2006

8 comments

1,121 views