title: All possible combinations from 3 columns of a table in oracle
body: <p>I am looking for some sort of example or idea how I can create all possible combinations from 3 columns of a database table in oracle.</p>
  <p>I have data like below table-</p>
  <pre><code>Name ID CODE POS_4 POS_5 POS_6
  XJ   21 SAJ     A   
  XJ   21 SAJ         A   
  XJ   21 SAJ         C   
  XJ   21 SAJ         J   
  XJ   21 SAJ         L   
  XJ   21 SAJ               10
  XJ   21 SAJ               12
  XJ   21 SAJ               14
  </code></pre>
  <p>And result I am expecting like below-</p>
  <pre><code>A_A_10
  A_A_12
  A_A_14
  A_C_10
  A_C_12
  A_C_14
  and so on...
  </code></pre>
  <p>Any help would be highly appreciated.</p>