Oracle CTE Merge Oracle CTE Merge oracle oracle

Oracle CTE Merge


The WITH clause is for use with a SELECT statement.

From the documents:"You can specify this clause in any top-level SELECT statement and in most types of subqueries." (emphasis mine).

Here is a possible workaround if you really need to do this, from ORAFAQ. The main blog writeup is here.