Database Software

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 parsing query

581427Aug 15 2007 — edited Aug 16 2007

Hi
I have a string like this " Oracle is a very fine Database" and a table with look up words in a column.
Now the query is, I should be able to parse this string and compare each word in this string with the values in the column
Retain the word as is in the string, if it matches else append the word in the string with the number 1, on a nonmatch.

Is there a special function to do accomplish this parsing in Ora 10g?

For example
Lets say I have all the words in the column except Oracle. Then I should get the string to be "Oracle1 is a very fine Database.

Any ideas will be much appreciated
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2007

Added on Aug 15 2007

#database-key-features, #text

2 comments

4,799 views