Oracle Scratchpad

June 10, 2020

CTE Catalogue

Filed under: Oracle,Subquery Factoring — Jonathan Lewis @ 6:46 pm BST Jun 10,2020

This note is an index of the articles I’ve written about Subquery Factoring (aka Common Table Expressions / CTEs, aka “with” subqueries).

Articles are listed in reverse order of publication and each article is date stamped, but the list is not yet complete.


  1. […] you’ve ever used subquery factoring (“with” subqueries or common table expressions (CTEs) as they are often called) then […]

    Pingback by Inline Hint | Oracle Scratchpad — October 9, 2020 @ 12:46 pm BST Oct 9,2020 | Reply

  2. […] CTE / “with subquery” catalogue […]

    Pingback by Catalog Catalogue | Oracle Scratchpad — January 25, 2022 @ 12:22 pm GMT Jan 25,2022 | Reply

  3. […] written the example up using subquery factoring; in earlier versions of Oracle the relevant piece of code would have been written as an inline […]

    Pingback by Five Hints | Oracle Scratchpad — October 21, 2022 @ 12:11 pm BST Oct 21,2022 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by

%d bloggers like this: