Hi All,
I have a local variable in my pl/sql package.It will get assigned some value each time based upon the conditions in the loop.The value in the variable is not stored in any tables but just pulled in the output of the concurrent program for each record.Is there any way that i can total the sum of the variable from all the records and show in the output file .
Example:
Record Variable Value
1 20
2 30
3 40
4 10
I want to show like the sum of the variable from all records is 100 but the variable value is not storing in any of the tables and i am printing in the concurrent output.Any ideas please.
Thanks,