Oracle - update only one row without using rowid
<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>