title: Query to schedule a match between each team
body: <p>How to fetch Below Output Using SQL Query in Oracle</p>
  
  <p>Scenario:    </p>
  
  <p>suppose that in a Table named Team contains  4 records, we need to schedule a match between each team vs opposite team:  </p>
  
  <pre><code> Team
      ----
      India
      Pakistan
      Srilanka
      Australia
  
  
      Output :
      ----
      India VS Pakistan
      India VS Srilanka
      India VS Australia
      Pakistan VS Srilanka
      Pakistan VS Australia
      Srilanka VS Australia
  </code></pre>