Updating a table with record type object
<p>I have a table say <code>EMPLOYER</code> with <code>EMPLOYER_ID</code> as the primary key. I write the following script to update a row in the table:</p>

<pre><code>declare
    emp_row EMPLOYER%ROWTYPE;
begin
    select * into emp_row from EMPLOYER where rownum &lt;= 1;
    emp_row.NAME := 'ABC';
    emp_row.AGE  := 99;
    -- Can I write something like below?
    update EMPLOYER set ??? = emp_row where EMPLOYER_ID = emp_row.EMPLOYER_ID;
end;
</code></pre>

<p>Can I update a row with a record type object in a single statement? Just as shown in the example above.</p>