Re: Oracle Left Outer Join and totals

bbcrock_at_gmail.com wrote:
> I rewrote the query using this concept and I think it works better than
> my solution.
>
> Despite 15 years of SQL experience, I am not so great with subselects.
>
> Don
>

It's actually a dynamic view (i.e. it's defined in the main query). Think of subselects, views (dynamic or static), and tables in a SELECT as simply data sources. You can pull data from any of them. If you don't have a data source that formats the data you need for your query exactly the way you need it, dynamic views are great for overcoming that.

In this case you could have created a real view to if you wanted to, but I say why bother cluttering up the data dictionary unless you have to. If this is the only place it's being used, I'd just keep it dynamic. Received on Tue May 23 2006 - 09:17:36 CDT