title: Get ID of updated record in Oracle update trigger pl/sql
body: <p>I have an employee table and trying to log the update/delete operations of employee table into a log table. 
  Emp table: </p>
  
  <pre><code>ID NAME ReviewerID
  1   A   101
  2   B   102
  3   C   101
  </code></pre>
  
  <p>If I perform an update operation, then I want to retrieve the ID of that particular record</p>
  
  <pre><code>DECLARE 
  P_ID INTEGER:
  ....
  WHEN UPDATING('ReviewerID') THEN
  SELECT ID INTO P_ID 
  FROM EMP 
  WHERE ReviewerID = :new.ReviewerID
  .....
  </code></pre>
  
  <p>If I update ReviewerID of B to 101, then I get an error of multiple rows fetched which I believe is true. How to retrieve ID ? Please help me with the logic </p>