Hi,
I am storing amounts in my nested table. how do i sum them up?is it possible to do it without looping?
<code>
declare
Type DlrLgrRecType is Record(
debit_amt NUMBER(12,2),
credit_amt NUMBER(12,2), -- i want to sum up all the values stored in the pl sql table
balance_amt NUMBER(12,2) -- i want to sum up all the balance_amt stored in the pl sql table
);
Type DlrLgrTabType is table of DlrLgrRecType;
</code>