SQL & PL/SQL

Hi All,

    My requirement is to compare a table of records with actual data in a table say, 'employee'

How will I compare data in table of records with actual table data for any updates and return the delta or changes.

I have written a skeleton procedure.

TABLE OF EMPLOYEES%ROWTYPE INDEX BY PLS_INTEGER;

PROCEDURE calculate_emp_delta(emp_in employees, emp_delta OUT employees)

   IS

    CURSOR c_employees

    IS

       SELECT re.first_name,

              re.second_name,

              re.position_number,

              re.position_start_date

         FROM employees re;

    cr_employee             c_employees%ROWTYPE;

   BEGIN

--Code to be added.

   null;

   END;

How to compare emp_in and what is available in the cursor and return the delta. Please advise.

Thanks