
---confkolom---


--1 rp1penduduk
delete from confkolom where urut=1;
insert into confkolom values(1,'tahun',1);
insert into confkolom values(1,'propinsi',2);
insert into confkolom values(1,'laki',3);
insert into confkolom values(1,'perempuan',4);

--2 rp1_umurtunggal
delete from confkolom where urut=2;
insert into confkolom values(2,'tahun',1);
insert into confkolom values(2,'propinsi',2);
insert into confkolom values(2,'lu1',3);
insert into confkolom values(2,'pu1',4);
insert into confkolom values(2,'lu2',5);
insert into confkolom values(2,'pu2',6);
insert into confkolom values(2,'lu3',7);
insert into confkolom values(2,'pu3',8);

--3 rp1kelumur
delete from confkolom where urut=3;
insert into confkolom values(3,'tahun',1);
insert into confkolom values(3,'propinsi',2);
insert into confkolom values(3,'lu1',3);
insert into confkolom values(3,'pu1',4);
insert into confkolom values(3,'lu2',5);
insert into confkolom values(3,'pu2',6);
insert into confkolom values(3,'lu3',7);
insert into confkolom values(3,'pu3',8);
insert into confkolom values(3,'lu4',9);
insert into confkolom values(3,'pu4',10);
insert into confkolom values(3,'lu5',11);
insert into confkolom values(3,'pu5',12);
insert into confkolom values(3,'lu6',13);
insert into confkolom values(3,'pu6',14);
insert into confkolom values(3,'lu7',15);
insert into confkolom values(3,'pu7',16);
insert into confkolom values(3,'lu8',17);
insert into confkolom values(3,'pu8',18);
insert into confkolom values(3,'lu9',19);
insert into confkolom values(3,'pu9',20);
insert into confkolom values(3,'lu10',21);
insert into confkolom values(3,'pu10',22);
insert into confkolom values(3,'lu11',23);
insert into confkolom values(3,'pu11',24);
insert into confkolom values(3,'lu12',25);
insert into confkolom values(3,'pu12',26);
insert into confkolom values(3,'lu13',27);
insert into confkolom values(3,'pu13',28);
insert into confkolom values(3,'lu14',29);
insert into confkolom values(3,'pu14',30);
insert into confkolom values(3,'lu15',31);
insert into confkolom values(3,'pu15',32);
insert into confkolom values(3,'lu16',33);
insert into confkolom values(3,'pu16',34);


--4 rp1kawin
delete from confkolom where urut=4;
insert into confkolom values(4,'tahun',1);
insert into confkolom values(4,'propinsi',2);
insert into confkolom values(4,'laki',3);
insert into confkolom values(4,'perempuan',4);




--5 rp1statuswn
delete from confkolom where urut=5;
insert into confkolom values(5,'tahun',1);
insert into confkolom values(5,'propinsi',2);
insert into confkolom values(5,'wniLaki',3);
insert into confkolom values(5,'wniPerempuan',4);






--6 rp1darah
delete from confkolom where urut=6;
insert into confkolom values(6,'tahun',1);
insert into confkolom values(6,'la',2);
insert into confkolom values(6,'lb',3);
insert into confkolom values(6,'lab',4);
insert into confkolom values(6,'lo',5);
insert into confkolom values(6,'pa',6);
insert into confkolom values(6,'pb',7);
insert into confkolom values(6,'pab',8);
insert into confkolom values(6,'po',9);


--7 rp1keluarga
delete from confkolom where urut=7;
insert into confkolom values(7,'tahun',1);
insert into confkolom values(7,'propinsi',2);
insert into confkolom values(7,'jumlah',3);


--8 rp1agama
delete from confkolom where urut=8;
insert into confkolom values(8,'tahun',1);
insert into confkolom values(8,'propinsi',2);
insert into confkolom values(8,'lislam',3);
insert into confkolom values(8,'lkristen',4);
insert into confkolom values(8,'lprotestan',5);
insert into confkolom values(8,'lhindu',6);
insert into confkolom values(8,'lbudha',7);
--insert into confkolom values(8,'lkonghucu',8);
--insert into confkolom values(8,'lkepercayaan',9);
insert into confkolom values(8,'pislam',8);
insert into confkolom values(8,'pkristen',9);
insert into confkolom values(8,'pprotestan',10);
insert into confkolom values(8,'phindu',11);
insert into confkolom values(8,'pbudha',12);
--insert into confkolom values(8,'pkonghucu',15);
--insert into confkolom values(8,'pkepercayaan',16);



--9 rp1tenagaKerja
delete from confkolom where urut=9;
insert into confkolom values(9,'tahun',1);
insert into confkolom values(9,'propinsi',2);
insert into confkolom values(9,'lku1',3);
insert into confkolom values(9,'pku1',4);
insert into confkolom values(9,'lku2',5);
insert into confkolom values(9,'pku2',6);
insert into confkolom values(9,'lku3',7);
insert into confkolom values(9,'pku3',8);
insert into confkolom values(9,'lku4',9);
insert into confkolom values(9,'pku4',10);



--10 rp1pekerjaan
delete from confkolom where urut=10;
insert into confkolom values(10,'tahun',1);
insert into confkolom values(10,'propinsi',2);
insert into confkolom values(10,'lk1',3);
insert into confkolom values(10,'pk1',4);
insert into confkolom values(10,'lk2',5);
insert into confkolom values(10,'pk2',6);
insert into confkolom values(10,'lk3',7);
insert into confkolom values(10,'pk3',8);
insert into confkolom values(10,'lk4',9);
insert into confkolom values(10,'pk4',10);
insert into confkolom values(10,'lk5',11);
insert into confkolom values(10,'pk5',12);
insert into confkolom values(10,'lk6',13);
insert into confkolom values(10,'pk6',14);
insert into confkolom values(10,'lk7',15);
insert into confkolom values(10,'pk7',16);
insert into confkolom values(10,'lk8',17);
insert into confkolom values(10,'pk8',18);
insert into confkolom values(10,'lk9',19);
insert into confkolom values(10,'pk9',20);
insert into confkolom values(10,'lk10',21);
insert into confkolom values(10,'pk10',22);
insert into confkolom values(10,'lk11',23);
insert into confkolom values(10,'pk11',24);
insert into confkolom values(10,'lk12',25);
insert into confkolom values(10,'pk12',26);
insert into confkolom values(10,'lk13',27);
insert into confkolom values(10,'pk13',28);
insert into confkolom values(10,'lk14',29);
insert into confkolom values(10,'pk14',30);
insert into confkolom values(10,'lk15',31);
insert into confkolom values(10,'pk15',32);
insert into confkolom values(10,'lk16',33);
insert into confkolom values(10,'pk16',34);
insert into confkolom values(10,'lk17',35);
insert into confkolom values(10,'pk17',36);
insert into confkolom values(10,'lk18',37);
insert into confkolom values(10,'pk18',38);
insert into confkolom values(10,'lk19',39);
insert into confkolom values(10,'pk19',40);
insert into confkolom values(10,'lk20',41);
insert into confkolom values(10,'pk20',42);
insert into confkolom values(10,'lk21',43);
insert into confkolom values(10,'pk21',44);


































