Oracle 10g SQL - Parsing Delimited String

Vikram Vaidyanathan <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <[email protected]>
I need to write a generic SQL query to parse a comma delimited string from right to left and return the first non-null value.
 
Example: 
1.  ,,,Database,,10g,,Oracle,,
2.  ,,10g,,,Oracle,,,,,,
3.  ,,,Data,,,Menu,,,Oracle,,,
 
For all the above examples, the output should be "Oracle" 
 
Appreciate the help.
 
Thanks,
Vikram
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.