title: How to get status of employees according to updates with the dates
body: <p>I have one table as empl with records as</p>
  <pre><code>EMPID   SDATE       SAL     DESIGNATION
  =======================================
  1001    21-SEP-17   55000   Technology Analyst
  1002    22-SEP-19   52000   Technology Analyst
  1003    15-SEP-17   65000   Technology Lead
  1004    21-SEP-15   72000   Technology Lead
  1005    11-MAR-20   55000   SSE
  1006    22-JAN-20   55000   SSE
  </code></pre>
  <p>We need to update the startDate with the next Date (as sysdate or 1 week later) for all the employees, batches wise (designation wise) in PLSQL keeping in mind the performance.
  while updating --&gt; log records in some any table (<strong>emp_log</strong>) with the Updation status like below if updation got succeeded for particular employee then status would be <strong>Success</strong> &amp; if updation got failed for some employees then status would be <strong>Failed</strong>.</p>
  <pre><code>empid   Update_Status
  =====================
  1001     Success
  1002     Failed
  1003     Success
  .....
  </code></pre>
  <p>What would be PL/SQL block statement to get this type of status with <strong>empid</strong>?</p>