title: How can I create table as select (CTAS) in oracle?
body: <p>I need to use <code>CTAS (Create Table As Select)</code> to create a table named <code>Au_Books_ZL</code> that contains <code>au_id, fname, lname, title_id, title, Pub_id, price and revenue (which is price*sales)</code>. </p>
  
  <p>I have browsed other questions online, but they don't show how to include all the attributes (lname, fname, title_id ect.) in the query. How could I write up my CTAS to create the new table?</p>