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