Populating a table.....
I'm placing the question here because it really isn't pressing to accomplish the task I have in mind.
First, I'm not much of a programmer, second, I have taken time to research my problem.
My problem is this: I have this itching sensation on my backsi.....ooops, wrong forum...lol
In all seriousness. I would like to populate a table with data from another table. I have a table that is stuctured like this:
creditor varchar2(30),
service date,
cost number(5),
paid number date));
I would like to populate a second table that would look like this:
creditor varchar2(30),
sumOfCost number(5));
Th sql I would like to use is select creditor, sum(cost) from table group by creditor.
What pl/sql would accomplish this?
Rick
Sigh.....those were the days my friend, I thought they'd never end.
I too remember when this place was coo.