title: Rollback in PLSQL Exception
body: <p>Would like to know whether rollback is required when a SQL exception (exception when others) is detected:</p>
  
  <pre><code>declare
   cursor c_test is
      select    *
      from  tesing;
      begin
         for rec in c_test loop
         begin
             update test1 set test1.name=rec.name where test1.id=rec.id;
             IF sql%rowcount = 1 THEN
                              commit;
             ELSIF   sql%rowcount =0 THEN
                     dbms_output.put_line('No Rows Updated');
             else
                    dbms_output.put_line('More than 1 row exists');
                    rollback;
             END IF;
         exception when others then
                    dbms_output.put_line(Exception');
                    rollback;
        end;      
  
  end;
  </code></pre>