troubleshooting Question

Compare SQL Query Result Set Column Names to the Column Names in an exising Table

Avatar of ThomasCox
ThomasCox asked on
Oracle Database
9 Comments3 Solutions540 ViewsLast Modified:
I know how to compare the column names in two tables by querying the SYS.All_Tab_COLUMNS Table.  

However, I want to compare the columns in an existing table in the SYS.All_Tab_COLUMNS Table to the Column Names in the Result Set of a SQL Query.

l have been looking all over and cannot find a resolution.

Join our community to see this answer!
Unlock 3 Answers and 9 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 3 Answers and 9 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