Re: Analyzing This Query?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 13 Feb 2006 09:02:29 -0800
Message-ID: <1139848197.999720.211300@g47g2000cwa.googlegroups.com>

TIA, the two column involved are not just being checked for a value, but the two values are being converted into 10 columns for each row in the result set. That makes this a pivoting or pivot table problem. There are other ways to pivot the table.

You can search the group archives (via google) or visit the http://asktom.oracle.com site and search on pivot to find alternate solutions.

The posted code has the advantage of being simple to understand. You could substitute a CASE statement for the decodes.

HTH -- Mark D Powell -- Received on Mon Feb 13 2006 - 11:02:29 CST