Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

The difference between "WITH clause" and derived tables (inline views)

511303Apr 9 2008 — edited Apr 9 2008
What's the difference between (1) the WITH clause and (2) inline views (derived tables) following the FROM clause in SELECT statement? Seems that they are doing the same job.

What can we do with the WITH subquery factoring clause that we cannot do with derived tables and vice versa?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2008
Added on Apr 9 2008
2 comments
469 views