title: Oracle INSERT into two tables in one query
body: <p>Just wondering if it is possible to run an INSERT into two tables in a single query for Oracle 11g?</p>
  
  <p>I know you can do a INSERT ALL ... SELECT query, but I need to do this without the SELECT as this is data coming straight from XLS into the database.</p>
  
  <p>ideally I'd want something like this example:</p>
  
  <pre><code>INSERT INTO table1 t1, table2 t2 
  (t1.tid, t1.date, t1.title, t2.tid, t2.date, t2.user, t2.note)
  VALUES (1,'01-JAN-15','title',1,'01-JAN-15','john','test note');
  </code></pre>
  
  <p>Any ideas?</p>