Oracle 11g Split column value and then find matching rows to create single row
I really don't know how to do this:
I want to split a value such as 123-456-789-0 into it's constituent parts and then find all the matching rows in a table and subsequently create a single row from the results. If you review the attached file, you will see example data for the starting point and the end result.
It is important to understand that when the values are found and joined together, the resulting column order is important (as the example data will show you)