create table provincie_temp(
DESC_PROV varchar2(20) not null,
CODI_PROV VARCHAR2(3) not null,
CODI_REGI VARCHAR2(3) not null)
insert into provincie_temp values ('L''AQUILA','066','130');
insert into provincie_temp values ('CHIETI','069','130');
insert into provincie_temp values ('PESCARA','068','130');
insert into provincie_temp values ('TERAMO','067','130');
insert into provincie_temp values ('ROMA','058','120');
insert into provincie_temp values ('RIETI','057','120');
insert into provincie_temp values ('VITERBO','056','120');
insert into provincie_temp values ('LATINA','059','120');
insert into provincie_temp values ('FROSINONE','060','120');
insert into provincie_temp values ('NAPOLI','063','150');
create table cliente_prov_regi(
codi_clie number(6) not null,
codi_regi VARCHAR2(3) ,
codi_prov VARCHAR2(3) not null)
insert into cliente_prov_regi values ('1',NULL,'058');
insert into cliente_prov_regi values ('1',NULL,'057');
insert into cliente_prov_regi values ('1',NULL,'056');
insert into cliente_prov_regi values ('1',NULL,'059');
insert into cliente_prov_regi values ('1',NULL,'060');
insert into cliente_prov_regi values ('1',NULL,'066');
insert into cliente_prov_regi values ('1',NULL,'067');
insert into cliente_prov_regi values ('1',NULL,'068');
insert into cliente_prov_regi values ('1',NULL,'063');