title: Use temporary inside another temporary table in Oracle 18
body: <p>is possible in Oracle18, to use a temporary table inside another temporary table?
  Example below:</p>
  
  <pre><code>CREATE PRIVATE TEMPORARY TABLE ora$ptt_today_sales 
  ON COMMIT PRESERVE DEFINITION
  AS
  SELECT * FROM orders WHERE order_date = SYSDATE;
  
  
  CREATE PRIVATE TEMPORARY TABLE ora$information 
  ON COMMIT PRESERVE DEFINITION
  AS
  SELECT * FROM ora$ptt_today_sales WHERE customerID=5;
  </code></pre>