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!

Query to Reverse of a word

KalpataruNov 9 2012 — edited Nov 20 2012
Hi all,
i want to reverse the words any word or sentences
for example
string require
--------------- ----------
MY NAME IS RAMA RAMA IS MY NAME
HE IS GOOD GOOD IS HE

and another query i want is that
i have a lot of descriptions like
FREE PRODUCT SIZE 10 M
FREE PRODUCT SIZE 20 M
FREE PRODUCT SIZE 30 M
ABC 123 ORACLE 123
ABC 123 XYZ 123
ABC 123 KLM 123
i don't know what will be the string will come but i want to cut the common/repeated strings
like in above example
i want only
SIZE 10 M
SIZE 20 M
SIZE 30 M
ORACLE 123
XYZ 123
KLM 123

please replay.
This post has been answered by Solomon Yakobson on Nov 12 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2012
Added on Nov 9 2012
29 comments
2,586 views