title: how to combine two columns from different tables and get single column
body: <p>I have two tables table A and table B . </p>
  
  <p>Table A contain column colA which contains values (1,3,5,7)</p>
  
  <p>Table B contain column colB which contains values (2,4,6,8)</p>
  
  <p>My query is how can i combine these two tables and get one column with output (1,2,3,4,5,6,7,8)</p>
  
  <p>I am using oracle 10g</p>