title: Find all possible combinations column value in ORACLE SQL
body: <p>Could you please help me to solve this Below Query:</p>
  <p>I have below table of data.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">EmpNo</th>
  <th style="text-align: center;">Name</th>
  <th style="text-align: left;">City</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">John</td>
  <td style="text-align: left;">US</td>
  </tr>
  <tr>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">Miranda</td>
  <td style="text-align: left;">US</td>
  </tr>
  <tr>
  <td style="text-align: center;">3</td>
  <td style="text-align: center;">Pete</td>
  <td style="text-align: left;">US</td>
  </tr>
  <tr>
  <td style="text-align: center;">4</td>
  <td style="text-align: center;">Jack</td>
  <td style="text-align: left;">US</td>
  </tr>
  <tr>
  <td style="text-align: center;">5</td>
  <td style="text-align: center;">Kathy</td>
  <td style="text-align: left;">UK</td>
  </tr>
  <tr>
  <td style="text-align: center;">6</td>
  <td style="text-align: center;">Tanni</td>
  <td style="text-align: left;">UK</td>
  </tr>
  <tr>
  <td style="text-align: center;">7</td>
  <td style="text-align: center;">Sally</td>
  <td style="text-align: left;">UAE</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want output as like below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">City</th>
  <th style="text-align: center;">Name1</th>
  <th style="text-align: center;">Name2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">US</td>
  <td style="text-align: center;">John</td>
  <td style="text-align: center;">Miranda</td>
  </tr>
  <tr>
  <td style="text-align: center;">US</td>
  <td style="text-align: center;">John</td>
  <td style="text-align: center;">Pete</td>
  </tr>
  <tr>
  <td style="text-align: center;">US</td>
  <td style="text-align: center;">John</td>
  <td style="text-align: center;">Jack</td>
  </tr>
  <tr>
  <td style="text-align: center;">US</td>
  <td style="text-align: center;">Miranda</td>
  <td style="text-align: center;">Pete</td>
  </tr>
  <tr>
  <td style="text-align: center;">US</td>
  <td style="text-align: center;">Miranda</td>
  <td style="text-align: center;">Jack</td>
  </tr>
  <tr>
  <td style="text-align: center;">US</td>
  <td style="text-align: center;">Pete</td>
  <td style="text-align: center;">Jack</td>
  </tr>
  <tr>
  <td style="text-align: center;">UK</td>
  <td style="text-align: center;">Kathy</td>
  <td style="text-align: center;">Tanni</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>PLSQL we can write block to get this output. But is it possible to get output using SQL code alone?</p>