Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

PL/SQL 101 : WITH Clause

BluShadowJan 20 2017 — edited Mar 14 2023

Often misunderstood by people new to SQL, the WITH clause (known in other databases as Common Table Expressions or CTE's, but in Oracle is known as the Subquery Factoring Clause), aside from being difficult to find in the documentation (if you don't know where to look), has many good uses. The attached PDF document details the uses of WITH with some examples.

PLSQL 101 - WITH Clause.pdf

(Edit: Now re-uploaded for new forum platform)

Comments
Post Details
Added on Jan 20 2017
8 comments
5,116 views