title: Oracle - update only one row without using rowid
body: <p>I am trying to <code>update</code> a <code>view</code> table, but only the first result from it.
  I cannot use <code>rowid</code> - not working on <code>view</code> table.
  Is there a way to update only the first <code>row</code>? as I said using <a href="https://stackoverflow.com/questions/244671/update-statement-in-oracle-using-sql-or-pl-sql-to-update-first-duplicate-row-onl">rowid</a>
  solutions could not work.
  <code>select</code> query example:</p>
  
  <pre><code>select addr
  from addrView
  where (tl = '7' and tr = '2')
  </code></pre>
  
  <p>returns 4 <code>results</code>, but when using <code>update</code>:</p>
  
  <pre><code>update addrView
  set home='current'
  where (tl = '7' and tr = '2')
  </code></pre>
  
  <p>I still want to upadte the first row.</p>