title: How to get row number from selected rows in Oracle
body: <p>I am selecting few rows from database e.g.:</p>
  
  <pre><code>select * from student where name is like %ram%
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>ID   Name     email          Branch
  7    rama    rama@gmail.com    B1
  5    ramb    ramb@gmail.com    B2
  3    ramc    ramc@gmail.com    B3
  8    ramd    ramd@gmail.com    B4
  11   rame    rame@gmail.com    B5
  12   ramf    ramf@gmail.com    B6
  14   ramg    ramg@gmail.com    B7
  </code></pre>
  
  <p>I need to get row number for which branch is B5. Expected value is "5"</p>
  
  <p>Can someone please suggest How to implement this in query ?</p>