title: Can a row be deleted by specifying ROWNUM in Oracle 11g?
body: <p>I have some values as below:</p>
  
  <pre><code>MYSTRING
  --------
  Dharshan
  Ramalingam
  Devid
  </code></pre>
  
  <p>I can select the specific row value through below query </p>
  
  <pre><code>select * from ( select mystring , rownum rn  FROM teststring  )
  </code></pre>
  
  <p>where  rn = 2;</p>
  
  <p>tell the way to delete this second row giving the row no and give me the brief explanation  . I have tried as below but its not work.... </p>
  
  <pre><code>delete   from testring where rownum=2;
  </code></pre>