title: Oracle SQL - Alternative to the UNION ALL statement
body: <p>Given the follownig query that uses a union,</p>
  
  <pre><code>Select col1,col2,col3,col4,col5,cast(multiset(temp.col1 from table(cast(xslt.children as clob_nt)) temp, col6
  from tableA
  union all
  Select a,b,c,d,e,cast(multiset(temp.col1 from table(cast(tableB.children as clob_nt)) temp, col7
  from tableB
  </code></pre>
  
  <p>i would expect to get the following output (i.e. rows from both tables)</p>
  
  <pre><code>tableA.x tableA.x tableA.x tableA.x tableA.x tableA.clob(x) tableA.x
  tableA.x tableA.x tableA.x tableA.x tableA.x tableA.clob(x) tableA.x
  tableB.x tableA.x tableA.x tableB.x tableB.x tableB.clob(x) tableB.x
  tableB.x tableA.x tableA.x tableB.x tableB.x tableB.clob(x) tableB.x
  tableB.x tableA.x tableA.x tableB.x tableB.x tableB.clob(x) tableB.x
  </code></pre>
  
  <p>What other options are available that will allow me to run the query without using 'union' or 'union all' and get the same results </p>