title: Equivalent of R cbind() function in Oracle?
body: <p>I am new to sql and struggling to solve this very simple task.</p>
  
  <p>Considering,</p>
  
  <pre><code>    with table1 as (select '1' col1 from dual union
  select '2' col1 from dual union
  select 'NO_PATTERN' col1 from dual union
  select 'RANDOM_STUFF' col1 from dual)
      select * from table1;
  </code></pre>
  
  <p>and,</p>
  
  <pre><code>    with table2 as (select 'aaa' col2 from dual union
  select '4' col2 from dual union
  select 'qwewqeq' col2  from dual
  union select 'UUUUUU' col2 from dual)
      select * from table2;
  </code></pre>
  
  <p>I want to perform a <code>cbind()</code> between the two columns into a new table which is the "vertical union" of table1.[col1] and table2[col2].</p>
  
  <p>The <strong>EXPECTED</strong> solution is:</p>
  
  <pre><code>    with solution as (select '1' col1, 'aaa' col2 from dual union
  select '2' col1, '4' col2 from dual union
  select 'NO_PATTERN'  col1, 'qwewqeq' col2 from dual union
  select 'RANDOM_STUFF'  col1, 'UUUUUU'  col2 from dual)
      select * from solution;
  </code></pre>
  
  <p>Any idea?</p>