Re: With Clause
Date: Wed, 5 Nov 2008 11:11:38 -0800 (PST)
Message-ID: <3c9bbde1-6704-4228-b160-cff3e4d796cc@g17g2000prg.googlegroups.com>
On Nov 5, 2:05 am, raja <dextersu..._at_gmail.com> wrote:
> Hi,
>
> I had a look at the usage of WITH Clause, where a repeated subquery
> can be replaced using WITH clause which reduces the complexity of the
> query.
> Apart from this, i was not able to find anything regarding WITH
> Clause.
>
> Please reply to my doubts on WITH Clause :
> 1. Apart from subquery replacement, what are the other usages of WITH
> Clause ?
> 2. Will the performance increase if we are using WITH Clause, instead
> of a subquery ?
> 3. What is the difference between WITH Clause and correlated
> subquery ?
>
> Any other information regarding WITH Clause, please send them too.
>
> Thanks in Advance.
>
> With Regards,
> Raja.
A few SECONDS of google:
http://www.psoug.org/reference/with.html http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:524736300346304074 http://www.oracle.com/technology/products/oracle9i/daily/oct10.html http://www.singlequery.com/2006/12/using-the-oracle-with-clause/
et cetera.
jg
-- @home.com is bogus. "The Best Support is no Service Request." - Chris WarttickiReceived on Wed Nov 05 2008 - 13:11:38 CST