The performance improvement of using the ROWID is illustrated in the following example.
The example retrieves each of the 25,000 employee records, calculates a new salary for each employee, and then updates the employees’ salary.
You can also perform more complicated updates in Oracle.
You may wish to update records in one table based on values in another table.
I'm not understanding the requirements in getting from the input to the desired output.
For example, where does this row come from: 6 2 2 test aud1 data I have my table with the following data: fnd pid my_data 1 1 test aud1 data 2 1 test aud1 data I also have the below record : fnd pid my_data 3 2 test aud2 data 4 2 test aud3 data Now I have to check based on pid , so i will be passing two pids to my procedure i.e.
The actual salary calculation is not shown in this example.