I have a look up table or a list like this..(Could this be a look table?).
Ohter table CONSUMER with all records with zips and other info
I need to link by zip and give totals for every distinct cl in the cluster table
cl total_addresses total_mailables
LLK 56,320 32,830
ORG 120,802 100,005
How would I have to this using iterative loops with pl/sql and build the PENETRATION table?
I appreciate your help on this
I don't think you need any loop - thats just SQL
CREATE TABLE AS SELECT cl, sum(zip) from table_cluster group by cl;
On the syntax page for create table this is the last part (CREATE TABLE ..... [AS subquery])