Re: With Clause

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 Wartticki