Re: With Clause
Date: Thu, 6 Nov 2008 10:05:04 -0800 (PST)
Ad 1 - I found WITH to be a workaround for what I think is Oracle BUG with some bit complex FULL OUTER JOIN statements that wouldn't work as subqueries but worked as expected with WITH Clause.
On Nov 5, 11:05 am, raja <dextersu..._at_gmail.com> wrote:
> I had a look at the usage of WITHClause, where a repeated subquery
> can be replaced using WITHclausewhich reduces the complexity of the
> Apart from this, i was not able to find anything regarding WITHClause.
> Please reply to my doubts on WITHClause:
> 1. Apart from subquery replacement, what are the other usages of WITHClause?
> 2. Will the performance increase if we are using WITHClause, instead
> of a subquery ?
> 3. What is the difference between WITHClauseand correlated
> subquery ?
> Any other information regarding WITHClause, please send them too.
> Thanks in Advance.
> With Regards,
Received on Thu Nov 06 2008 - 12:05:04 CST