troubleshooting Question

SQL Query Help PLEASE!!!!!!

Avatar of eagle_ea
eagle_ea asked on
Oracle Database
30 Comments2 Solutions770 ViewsLast Modified:
Need help Experts!!
below is my requirement
i have table that contains list of database sid's
instance sid
1             sid1
2             sid2
3             sid3
4             sid4

another table that contains all the oracle parameter for any given sid form the previous table
db_instance            parameter                                  values
1                              sga_target                                      4GB
1                              _unnest_subquery                         FALSE
2                              sga_target                                      3GB
2                              _unnest_subquery                         FALSE
3                              _unnest_subquery                         TRUE

above are the data i currently have. what i need to derive out of this?
for any given pattern of sid, i need to compare all the parameter values
below, is an example of expected result

only if the parameter value is different between these databases, values are displayed

parameter                            sid1                            sid2                           sid3
sga_target                             4GB                            3GB                            4GB
_unnest_subquery               FALSE                         FALSE                         TRUE
Join our community to see this answer!
Unlock 2 Answers and 30 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 2 Answers and 30 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