troubleshooting Question

Oracle 11g - Join two tables based on complex query that splits values

Avatar of pm-archtect
pm-archtectFlag for United Kingdom of Great Britain and Northern Ireland asked on
Oracle Database
14 Comments1 Solution351 ViewsLast Modified:

I have two queries, one quite complex (courtesy of expert exchange user sdstuber) that splits a value in a column in to its constituent parts and then finds all the matching rows and pivots the data and another that is a simple select, from where.

Each of these queries and their data are in the attached example spreadsheet under tabs "Part One" and "Part Two".  You will in Part One how the simple column data is transfomed into a new set of rows.

What I need to do is join the resulting sets of data together and the example is in the third tab "Example Join".
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros