title: Oracle DELETE statement with subquery factoring
body: <p>Trying to do this (works in SQL Server):</p>
  
  <pre><code>WITH X AS (), Y AS (), Z AS ()
  DELETE FROM TBL
  WHERE TBL.ID IN (SELECT ID FROM Z);
  </code></pre>
  
  <p>This works in Oracle:</p>
  
  <pre><code>WITH X AS (), Y AS (), Z AS ()
  SELECT * FROM TBL
  WHERE TBL.ID IN (SELECT ID FROM Z);
  </code></pre>
  
  <p>But the DELETE does not: ORA-00928: missing SELECT keyword</p>
  
  <p>My subqueries are rather large, is there a different syntax to get this to work?</p>