inserts.sql

/* Inserts */


/*Para las imagenes debemos establecer las rutas*/
CREATE  DIRECTORY DIR_BANDERAS AS 'C:\img_proyecto\flags';
CREATE  DIRECTORY DIR_PROV AS 'C:\img_proyecto\prov';
CREATE  DIRECTORY DIR_PEOPLE AS 'C:\img_proyecto\people';
CREATE  DIRECTORY DIR_AIRLINES AS 'C:\img_proyecto\airlines';

/* TABLE patologias */
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Asma');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Bronquitis');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Bulimia');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Cancer');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Dengue');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Endocarditis');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Faringitis');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Glaucoma');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Gripe');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Insuficiencia cardiaca');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Neumonia');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Obesidad');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Pariotiditis');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Parkinson');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Rinitis');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Rotavitus');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Sarampión');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Sarcoidosis');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Sífilis');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Toxoplasmosis');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Urticaria');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Varicela');
INSERT INTO patologias VALUES (id_patologia_seq.nextval, 'Vasculitis');

/* TABLE sintomas */
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Cansancio');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Conjuntivitis');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Diarrea');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Dificultad para despertarse o permanecer despierto');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Dificultad respiratoria');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Dolor de garganta');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Dolor muscular');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Dolor o presíon en el pecho');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Erupciones cutáneas');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Escalofríos');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Fiebre');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Incapacidad para hablar');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Molestias y dolores');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Nauseas o vómitos');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Perdida de color en las manos');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Perdida del sentido del gusto');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Perdida del sentido del olfato');
INSERT INTO sintomas VALUES (id_sintoma_seq.nextval, 'Tos seca');
/
/* TABLE proveedores 
   Hay que hacerlo con un bloque anonimo para que se inserten las imagenes*/
DECLARE 
  v_blob BLOB;
  v_bfile BFILE;
BEGIN
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'AOL', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'aol.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'AT&.T', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'atyt.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'CANTV', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'cantv.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Claro', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'claro.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Clearwire', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'clearwire.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Entel', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'entel.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Movistar', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'movistar.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Orange', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'orange.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Singapur Telecomunicaciones', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'singtel.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Speedy', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'speedy.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Starlink', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'starlink.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Telmex', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'telmex.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'UUnet', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'uunet.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'Verizon', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'verizon.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO proveedores VALUES (id_proveedor_seq.nextval, 'VTR', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_PROV', 'vtr.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
END;
/
/* TABLE aerolineas
   Hay que hacerlo con un bloque anonimo para que se inserten las imagenes*/
DECLARE 
  v_blob BLOB;
  v_bfile BFILE;
BEGIN
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Allegiant Air', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'allegiant.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Air France', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'airfrance.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'American Airlines', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'american_airlines.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Avianca', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'avianca.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Avior Airlines', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'avior.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Conviasa', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'conviasa.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Grupo Lufthansa', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'lufthansa.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Delta Air Lines', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'delta.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Estelar', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'estelar.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Frointer Airlines', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'frontier.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Laser Airlines', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'laser.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Pegasus Airlines', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'pegasus.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Ryanair', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'ryanair.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Santa Barbara AirLines', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'santa_barbara.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO aerolineas VALUES (id_aerolinea_seq.nextval, 'Sky Airline', EMPTY_BLOB()) RETURNING img INTO v_blob;
    v_bfile := BFILENAME('DIR_AIRLINES', 'sky.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
END;
/
/* TABLE insumos */
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Agua destilada');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Agua oxigenada');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Alcohol');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Algodon');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Ampicilina');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Bisturi');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Cateter intravenoso');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Diclofenaco');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Esparadrapo');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Gasa');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Guantes desechables');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Hilo de sutura');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Jeringas');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Mascarilla');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Metronidazol');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Paracetamol');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Suero cloruro de sodio');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Suero Dextrosa');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Termometro');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Venda Elastica');
INSERT INTO insumos VALUES (id_insumo_seq.nextval, 'Yodo');
/
/* TABLE paises  
   Hay que hacerlo con un bloque anonimo para que se inserten las imagenes*/
DECLARE 
  v_blob BLOB;
  v_bfile BFILE;
BEGIN
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'Alemania', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'de.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'Argentina', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'ar.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'Brasil', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'br.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'China', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'cn.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'España', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'es.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'Estados Unidos', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'us.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'Francia', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'fr.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'Mexico', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'mx.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'Reino Unido', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'gb.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'Venezuela', EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 've.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO paises VALUES (id_pais_seq.nextval, 'Escocia',EMPTY_BLOB()) RETURNING bandera INTO v_blob;
    v_bfile := BFILENAME('DIR_BANDERAS', 'gb-sct.png');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
END;
/
/* TABLE estados */
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Berlin', (SELECT id FROM paises WHERE nom = 'Alemania'), covid_data(3769));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Hesse', (SELECT id FROM paises WHERE nom = 'Alemania'), covid_data(6866));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Bremen', (SELECT id FROM paises WHERE nom = 'Alemania'), covid_data(5479));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Buenos Aires', (SELECT id FROM paises WHERE nom = 'Argentina'), covid_data(2890));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Ceara', (SELECT id FROM paises WHERE nom = 'Brasil'), covid_data(2643));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Hubei', (SELECT id FROM paises WHERE nom = 'China'), covid_data(5850));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Sichuan', (SELECT id FROM paises WHERE nom = 'China'), covid_data(8110));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Anhui', (SELECT id FROM paises WHERE nom = 'China'), covid_data(6200));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Edimburgo', (SELECT id FROM paises WHERE nom = 'Escocia'), covid_data(6200));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'California', (SELECT id FROM paises WHERE nom = 'Estados Unidos'), covid_data(3951));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Florida', (SELECT id FROM paises WHERE nom = 'Estados Unidos'), covid_data(2148));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Louisiana', (SELECT id FROM paises WHERE nom = 'Estados Unidos'), covid_data(4649));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Barcelona', (SELECT id FROM paises WHERE nom = 'España'), covid_data(5575));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Granada', (SELECT id FROM paises WHERE nom = 'España'), covid_data(9197));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Zaragoza', (SELECT id FROM paises WHERE nom = 'España'), covid_data(9680));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Paris', (SELECT id FROM paises WHERE nom = 'Francia'), covid_data(9683));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Tamaulipas', (SELECT id FROM paises WHERE nom = 'Mexico'), covid_data(9680));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Londres', (SELECT id FROM paises WHERE nom = 'Reino Unido'), covid_data(9680));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Distrito Capital', (SELECT id FROM paises WHERE nom = 'Venezuela'), covid_data(1943));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Lara', (SELECT id FROM paises WHERE nom = 'Venezuela'), covid_data(2019));
INSERT INTO estados VALUES (id_estado_seq.nextval, 'Zulia', (SELECT id FROM paises WHERE nom = 'Venezuela'), covid_data(3704));

/* TABLE ciudades */
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Wiesbaden', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Alemania' AND e.nom = 'Hesse'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Kassel', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Alemania' AND e.nom = 'Hesse'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Berlin', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Alemania' AND e.nom = 'Berlin'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Bremerhaven', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Alemania' AND e.nom = 'Bremen'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Chengdu', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'China' AND e.nom = 'Sichuan'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Wuhan', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'China' AND e.nom = 'Hubei'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Xiangyang', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'China' AND e.nom = 'Hubei'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Orlando', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Estados Unidos' AND e.nom = 'Florida'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Tampa', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Estados Unidos' AND e.nom = 'Florida'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'New Orleans', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Estados Unidos' AND e.nom = 'Louisiana'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Sacramento', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Estados Unidos' AND e.nom = 'California'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Fresno', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Estados Unidos' AND e.nom = 'California'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Caracas', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Venezuela' AND e.nom = 'Distrito Capital'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Basquisimeto', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Venezuela' AND e.nom = 'Lara'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Maracaibo', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Venezuela' AND e.nom = 'Zulia'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Fortaleza', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Brasil' AND e.nom = 'Ceara'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Sobral', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Brasil' AND e.nom = 'Ceara'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Juazeiro', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Brasil' AND e.nom = 'Ceara'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Sabadell', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'España' AND e.nom = 'Barcelona'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Villanueva', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'España' AND e.nom = 'Barcelona'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Gelsa', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'España' AND e.nom = 'Zaragoza'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Novillas', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'España' AND e.nom = 'Zaragoza'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Palermo', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Argentina' AND e.nom = 'Buenos Aires'));
INSERT INTO ciudades VALUES (id_ciudad_seq.nextval, 'Floresta', (SELECT e.id FROM paises p JOIN estados e ON p.id = e.id_pais WHERE p.nom = 'Argentina' AND e.nom = 'Buenos Aires'));

/* TABLE urbanizaciones */
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Charlottenburg', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Alemania' AND e.nom = 'Berlin' AND c.nom = 'Berlin'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Kreuzberg', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Alemania' AND e.nom = 'Berlin' AND c.nom = 'Berlin'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Tegel', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Alemania' AND e.nom = 'Berlin' AND c.nom = 'Berlin'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Parkway', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Estados Unidos' AND e.nom = 'California' AND c.nom = 'Fresno'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Lakeview', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Estados Unidos' AND e.nom = 'Louisiana' AND c.nom = 'New Orleans'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Tulane', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Estados Unidos' AND e.nom = 'Louisiana' AND c.nom = 'New Orleans'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Chunxi Road', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'China' AND e.nom = 'Sichuan' AND c.nom = 'Chengdu'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Jianghan Road', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'China' AND e.nom = 'Hubei' AND c.nom = 'Wuhan'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Zhongnan', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'China' AND e.nom = 'Hubei' AND c.nom = 'Wuhan'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Wuhouci', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'China' AND e.nom = 'Sichuan' AND c.nom = 'Chengdu'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'La Castellana', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Venezuela' AND e.nom = 'Distrito Capital' AND c.nom = 'Caracas'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Colinas de Bello Monte', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Venezuela' AND e.nom = 'Distrito Capital' AND c.nom = 'Caracas'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Montalban', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Venezuela' AND e.nom = 'Distrito Capital' AND c.nom = 'Caracas'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Ziruma', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Venezuela' AND e.nom = 'Zulia' AND c.nom = 'Maracaibo'));
INSERT INTO urbanizaciones VALUES (id_urbanizacion_seq.nextval, 'Las Delicias', (SELECT c.id FROM paises p JOIN estados e ON p.id = e.id_pais JOIN ciudades c ON e.id = c.id_estado WHERE p.nom = 'Venezuela' AND e.nom = 'Zulia' AND c.nom = 'Maracaibo'));

/* TABLE calles */
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'S. Rendon', 70119, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'S. Clark', 72626, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'Perdido', 53158, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'Baudin', 54510, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'S. Lopez', 72626, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'S. Salcedo', 75026, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'S. Genois', 51015, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'D Hemecourt', 21555, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'Gravier', 54106, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'S. Telemachus', 72005, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Tulane' AND c.nom = 'New Orleans' AND e.nom = 'Louisiana' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'Grant Avenue', 15483, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Parkway' AND c.nom = 'Fresno' AND e.nom = 'California' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'Maiden Lane', 12545, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Parkway' AND c.nom = 'Fresno' AND e.nom = 'California' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'State Street', 86527, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Parkway' AND c.nom = 'Fresno' AND e.nom = 'California' AND p.nom = 'Estados Unidos'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'S. Rick', 68548, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Charlottenburg' AND c.nom = 'Berlin' AND e.nom = 'Berlin' AND p.nom = 'Alemania'));
INSERT INTO CALLES VALUES (id_calle_seq.nextval, 'M. Smith', 11547, (SELECT u.id FROM URBANIZACIONES u JOIN ciudades c ON c.id = u.id_ciudad JOIN estados e ON e.id = c.id_estado JOIN paises p ON p.id = e.id_pais WHERE u.nom = 'Kreuzberg' AND c.nom = 'Berlin' AND e.nom = 'Berlin' AND p.nom = 'Alemania'));
/
/* TABLE personas
    Hay que hacerlo con un bloque anonimo para que se inserten las imagenes*/
DECLARE 
  v_blob BLOB;
  v_bfile BFILE;
BEGIN
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Frank', null, 'Hesse', 'Stokes', to_date('01/08/1999','DD/MM/YYYY'), null, 'M'),1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person01.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Leo', null, 'Barnes', 'Garrett', to_date('10/05/1999','DD/MM/YYYY'), null, 'M'),1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person04.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Carmina', 'Leonor', 'Zucceada', 'Snow', to_date('07/05/1999','DD/MM/YYYY'), null, 'F'),2) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person02.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Josh', null, 'Hamilton', 'Briggs', to_date('24/11/1999','DD/MM/YYYY'), null, 'M'),3) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person06.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Faryd', null, 'Morningstar', 'Leigh', to_date('17/04/1968','DD/MM/YYYY'), null, 'M'),1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person07.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Kim', 'Violet', 'Parker', 'Acosta', to_date('17/11/1999','DD/MM/YYYY'), null, 'F'),5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person05.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Ruby', 'Ariyan', 'Mikan', 'Cortes', to_date('14/08/1999','DD/MM/YYYY'), null, 'F'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person02.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Vladimir', null, 'Makarov', 'Anderson', to_date('04/10/1999','DD/MM/YYYY'), null, 'M'), 9) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person10.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Dmitri', null, 'Smirnov', 'Abott', to_date('14/07/1999','DD/MM/YYYY'), null, 'M'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person20.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Alex', null, 'Preobrazhensky', 'Mercer', to_date('17/04/1999','DD/MM/YYYY'), null, 'M'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person12.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Anna', null, 'Preobrazhensky', 'Duncan', to_date('27/09/1999','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person08.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Ivan', null, 'Kuznetsov', 'Bush', to_date('17/04/1999','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person09.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'John', null, 'Ki', 'Cheng', to_date('16/10/1999','DD/MM/YYYY'), null, 'M'), 2) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person26.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Emily', 'Rose', 'Leach', 'Nelson', to_date('07/11/1999','DD/MM/YYYY'), null, 'F'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person11.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Gregg', 'Mitchell', 'Spinetti', 'Jimenez', to_date('01/11/1999','DD/MM/YYYY'), null, 'M'), 9) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person23.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Niels', null, 'Petersen', 'Manson', to_date('08/11/1999','DD/MM/YYYY'), null, 'M'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person13.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Shia', null, 'Morgan', 'LaBeuf', to_date('08/11/1999','DD/MM/YYYY'), null, 'F'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person15.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Shelby', null, 'Morgan', 'Cook', to_date('01/12/1999','DD/MM/YYYY'), null, 'F'), 2) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person19.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Alice', null, 'Nightray', 'Bradford', to_date('08/07/1999','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person30.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Piero', 'Armando', 'Vilchez', 'Wilde', to_date('05/07/1999','DD/MM/YYYY'), null, 'M'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person14.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Omar', 'Jose', 'Hernandez', 'Barrera', to_date('07/07/1999','DD/MM/YYYY'), null, 'M'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person16.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Stefano', 'Dewey', 'Hernandez', 'Queen', to_date('01/05/1978','DD/MM/YYYY'), null, 'M'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person18.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jaz', 'Summer', 'Radke', 'Frey', to_date('01/12/1999','DD/MM/YYYY'), null, 'F'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person29.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Henry', null, 'Modrig', 'Rodriguez', to_date('07/11/1999','DD/MM/YYYY'), null, 'M'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person17.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Kylie', 'Aiza', 'Hann', 'Harrell', to_date('13/09/1999','DD/MM/YYYY'), null, 'F'), 3) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person25.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Gavin', null, 'Cringe', 'Preach', to_date('09/11/1999','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person27.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Alberto', 'Arturo', 'Gavin', 'Colmenares', to_date('12/12/1999','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person21.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Dia', null, 'Hansen', 'Gray', to_date('12/03/1999','DD/MM/YYYY'), null, 'F'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person28.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Kingsley', null, 'Coman', 'Jr', to_date('08/07/1999','DD/MM/YYYY'), null, 'M'), 9) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person24.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Cassie', null, 'Kench', 'Cantell', to_date('01/09/1999','DD/MM/YYYY'), null, 'F'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person38.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Ethan', null, 'Hartmann', 'Trevino', to_date('05/10/1999','DD/MM/YYYY'), to_date('19/06/2020','DD/MM/YYYY'), 'M'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person32.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Elizabeth', 'Alexa', 'Warren', 'Hernandez', to_date('08/10/1999','DD/MM/YYYY'), null, 'F'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person41.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Mary', 'Li', 'Chang', 'Wu', to_date('03/08/1999','DD/MM/YYYY'), null, 'F'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person43.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Alice', 'Johanna', 'Bradley', 'Payne', to_date('03/08/1999','DD/MM/YYYY'), null, 'F'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person44.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Samantha', 'Sofia', 'Weber', 'Wu', to_date('23/08/2019','DD/MM/YYYY'), null, 'F'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person45.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jhoan', 'Alejandro', 'Kennedy', 'Welch', to_date('16/07/1959','DD/MM/YYYY'), null, 'M'), 3) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person46.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Edward', null, 'Meyer', 'Wu', to_date('23/08/2017','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person47.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Nola', 'Kim', 'Cox', 'Bauer', to_date('23/08/1999','DD/MM/YYYY'), null, 'M'), 2) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person48.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Hudson', 'Li', 'Butt', 'Tang', to_date('11/11/2014','DD/MM/YYYY'), null, 'M'), 2) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person49.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Terrance', null, 'Mephesto', 'Harrison', to_date('23/07/2015','DD/MM/YYYY'), null, 'M'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person50.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Amber', 'Fire', 'Beck', 'Harrison', to_date('18/01/2009','DD/MM/YYYY'), null, 'F'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person51.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Dianne', 'Elsa', 'Goulding', 'Beck', to_date('17/06/1999','DD/MM/YYYY'), null, 'F'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person52.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Sandy', 'Isabella', 'Fernandez', 'Sutton', to_date('31/01/1999','DD/MM/YYYY'), null, 'F'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person53.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jeff', 'Andrew', 'Hardy', 'Nox', to_date('11/07/1999','DD/MM/YYYY'), null, 'M'), 9) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person54.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Paul', 'Alejandro', 'Darby', 'Caro', to_date('27/11/1999','DD/MM/YYYY'), null, 'M'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person55.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Alysson', 'Daniela', 'Bilal', 'Aguero', to_date('11/11/1999','DD/MM/YYYY'), null, 'F'), 3) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person56.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Alisa', null, 'Bosconovich', 'Becker', to_date('28/02/1957','DD/MM/YYYY'), null, 'F'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person57.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Patricia', null, 'Pie', 'Dominick', to_date('28/04/1999','DD/MM/YYYY'), null, 'F'), 2) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person59.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Cody', 'Ander', 'Mackay', 'McLovin', to_date('16/07/1975','DD/MM/YYYY'), null, 'M'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person58.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Elena', 'Alejandra', 'Browne', 'Levison', to_date('26/08/1999','DD/MM/YYYY'), null, 'F'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person60.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Lautaero', 'Jesus', 'Hamilton', 'Gonzalez', to_date('06/01/1999','DD/MM/YYYY'), null, 'M'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person61.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Eleanor', 'Jose', 'Wright', 'Weiss', to_date('06/01/1987','DD/MM/YYYY'), null, 'M'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person62.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Tyler', 'Alejandro', 'Nolan', 'Wainwright', to_date('11/11/2001','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person63.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Felicia', 'Johanna', 'Galbott', 'Baxter', to_date('11/04/2011','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person64.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Laura', 'Victoria', 'Kirk', 'Chung', to_date('07/07/2013','DD/MM/YYYY'), null, 'F'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person66.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Hazzet', null, 'Crismael', 'Howe', to_date('11/12/1994','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person67.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Tyler', 'Alejandro', 'Nolan', 'Wainwright', to_date('11/11/2001','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person65.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Tamika', 'Tanya', 'Allman', 'Kodd', to_date('24/06/1994','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person68.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Arturo', null, 'Corona', 'Oswell', to_date('21/12/1999','DD/MM/YYYY'), null, 'M'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person69.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Nocti', null, 'Caelum', 'Johnson', to_date('17/12/2001','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person79.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Johan', 'Hachim', 'Watzke', 'Reinhardt', to_date('04/12/1997','DD/MM/YYYY'), null, 'M'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person74.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Giles', null, 'Nightray', 'Orwell', to_date('01/01/1998','DD/MM/YYYY'), null, 'M'), 3) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person73.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Grace', 'Emillie', 'Lemming', 'Rehan', to_date('11/12/1998','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person71.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Viktoria', 'Nati', 'Pezhkov', 'Hernandez', to_date('11/12/1993','DD/MM/YYYY'), null, 'F'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person72.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Midori', null, 'Pavlichenko', 'Walter', to_date('02/07/1993','DD/MM/YYYY'), null, 'F'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person75.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Julianna', null, 'Korb', 'Meyer', to_date('01/07/1993','DD/MM/YYYY'), null, 'F'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person76.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Larissa', 'Lily', 'Martins', 'Orly', to_date('25/06/1993','DD/MM/YYYY'), null, 'F'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person77.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Anisha', 'Abril', 'Whitehead', 'Middleton', to_date('01/07/1995','DD/MM/YYYY'), null, 'F'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person78.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Alexandra', 'Keri', 'Ryder', 'Orr', to_date('17/03/1995','DD/MM/YYYY'), null, 'F'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person80.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Orphelia', 'Christine', 'Devan', 'Moore', to_date('11/01/2015','DD/MM/YYYY'), null, 'F'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person81.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Darren', null, 'Bloggs', 'Farrow', to_date('07/01/2017','DD/MM/YYYY'), null, 'M'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person82.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Christine', null, 'Arnold', 'Braun', to_date('01/03/1995','DD/MM/YYYY'), null, 'F'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person83.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Danyaal', 'Steve', 'McCarty', 'Maguire', to_date('20/04/1976','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person84.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jimi', null, 'Guevara', 'Kruse', to_date('07/06/2018','DD/MM/YYYY'), null, 'M'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person85.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Lexi', 'Xena', 'Nunez', 'Salazar', to_date('24/08/1995','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person86.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Daisy', 'Mane', 'Roldan', 'Goddard', to_date('21/04/1994','DD/MM/YYYY'), null, 'F'), 2) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person87.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Monika', 'Lucie', 'Beattie', 'Dupont', to_date('01/08/1969','DD/MM/YYYY'), null, 'F'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person88.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Romeo', 'Alonso', 'Williams', 'Richards', to_date('17/08/1945','DD/MM/YYYY'), null, 'M'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person89.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Alex', 'Luciano', 'Petersen', 'Orr', to_date('01/02/1975','DD/MM/YYYY'), null, 'M'), 2) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person90.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Rafael', null, 'Petit', 'Bradley', to_date('07/11/1993','DD/MM/YYYY'), null, 'M'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person91.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Carlos', 'Daniel', 'Solis', 'Russell', to_date('27/01/1955','DD/MM/YYYY'), null, 'M'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person92.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Rogan', 'Donald', 'Nashville', 'Rayner', to_date('04/12/1949','DD/MM/YYYY'), null, 'M'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person93.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Ruben', null, 'Bradley', 'Moran', to_date('02/01/1978','DD/MM/YYYY'), null, 'M'), 2) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person94.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Efe', null, 'Thompson', 'Rubio', to_date('14/06/2014','DD/MM/YYYY'), null, 'F'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person95.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Ella', 'Rose', 'Madinson', 'Woolley', to_date('25/06/1997','DD/MM/YYYY'), null, 'F'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person96.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Nasir', 'Ralphie', 'Zimmermann', 'Montoya', to_date('05/05/1996','DD/MM/YYYY'), null, 'F'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person97.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Phillipa', null, 'Wagner', 'Miller', to_date('24/09/1996','DD/MM/YYYY'), null, 'F'), 3) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person98.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Barbara', 'Nuala', 'Elliott', 'Isla', to_date('27/04/1992','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person99.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Coen', null, 'Avery', 'Trevino', to_date('27/04/1994','DD/MM/YYYY'), null, 'M'), 3) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person100.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Eliza', null, 'Skyes', 'Cortes', to_date('28/06/1995','DD/MM/YYYY'), null, 'F'), 3) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person101.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Katherine', 'Alejandra', 'Bouvet', 'Pitts', to_date('28/01/1994','DD/MM/YYYY'), null, 'F'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person102.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Bjorn', 'Nelson', 'Dowling', 'Skinner', to_date('19/06/1991','DD/MM/YYYY'), null, 'M'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person103.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Shola', 'Yassen', 'Baird', 'Soto', to_date('28/04/1992','DD/MM/YYYY'), null, 'F'), 1) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person104.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Kristen', null, 'Morris', 'Frost', to_date('26/04/1989','DD/MM/YYYY'), null, 'F'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person105.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Elly', 'Karen', 'O Conner', 'Cooke', to_date('26/12/1995','DD/MM/YYYY'), null, 'F'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person106.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jordy', 'Nasseem', 'Heath', 'Donovan', to_date('19/04/1993','DD/MM/YYYY'), null, 'M'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person107.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Shirley', null, 'Roldan', 'Feeney', to_date('21/06/1993','DD/MM/YYYY'), null, 'F'), 7) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person108.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Parker', 'Karim', 'Velazquez', 'Morse', to_date('20/01/1965','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person109.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Mai', null, 'Hayward', 'Pace', to_date('15/11/1994','DD/MM/YYYY'), null, 'F'), 10) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person110.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Anabella', 'Shaki', 'McHamon', 'Emery', to_date('07/11/1992','DD/MM/YYYY'), null, 'F'), 6) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person111.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Lexa', null, 'Cameron', 'Sanchez', to_date('01/11/1995','DD/MM/YYYY'), null, 'F'), 8) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person112.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Iona', 'Debra', 'Samuels', 'Vaughan', to_date('20/10/1994','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person113.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Thiago', 'Gregor', 'Alcantara', 'Murphy', to_date('09/11/1975','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person114.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Shona', null, 'Green', 'Orr', to_date('11/12/1991','DD/MM/YYYY'), null, 'F'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person115.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Emma', 'Isha', 'Beck', 'Terry', to_date('18/04/1985','DD/MM/YYYY'), null, 'F'), 5) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person116.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Carter', 'Jasiah', 'McBride', 'Brock', to_date('25/06/1995','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person117.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Kristin', null, 'Sheppard', 'McKnight', to_date('22/06/1993','DD/MM/YYYY'), null, 'F'), 9) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person118.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Patrik', 'Karson', 'Jordan', 'Stanton', to_date('26/08/1991','DD/MM/YYYY'), null, 'F'), 9) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person119.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Woody', null, 'Page', 'Hammer', to_date('21/05/1994','DD/MM/YYYY'), null, 'M'), 4) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person120.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);


    /* Otro Estado */
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Natalie', null, 'Wilson', 'Fletcher', to_date('21/05/1984','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person121.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Ada', 'Miracle', 'Pittman', 'Gray', to_date('21/05/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person122.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Michelle', 'Rhonda', 'Oakley', 'Ryan', to_date('01/08/1996','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person123.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Yajaira', 'Alejandra', 'Tait', 'Sierra', to_date('08/06/1964','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person124.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Sam', null, 'Gaines', 'Villanueva', to_date('30/09/1971','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person125.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Lenny', 'Alexander', 'Whitwhoth', 'Brown', to_date('08/12/1981','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person126.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Cameron', 'Denisse', 'Blanc', 'Rubio', to_date('21/05/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person127.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Safa', 'Dianna', 'Tabiyyah', 'Mohammed', to_date('14/08/1994','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person128.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Chad', null, 'Castro', 'Carey', to_date('18/05/1974','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person129.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jimena', 'Alejandra', 'Mckewon', 'Carey', to_date('16/01/1984','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person130.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Eboni', null, 'Carey', 'Hammer', to_date('11/01/1992','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person131.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Priscila', 'Priya', 'Wagner', 'Snaider', to_date('25/06/1991','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person132.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Woody', null, 'Page', 'Hammer', to_date('21/05/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person133.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Fredrick', 'Erick', 'Corbett', 'Vinson', to_date('19/05/1974','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person134.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Sadia', null, 'Lopez', 'Pitt', to_date('28/07/2014','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person135.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Paloma', null, 'Colley', 'Shaw', to_date('25/07/1997','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person136.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Gage', 'David', 'Wells', 'Welch', to_date('27/06/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person137.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Darcie', 'Rose', 'Pennington', 'Biazh', to_date('17/01/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person138.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Maria', 'De los Angeles', 'Molina', 'Coromoto', to_date('16/04/1986','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person139.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Rima', 'Diana', 'Arshavin', 'Irwin', to_date('24/05/1974','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person140.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Preston', 'Colin', 'Mcdougall', 'Gamble', to_date('17/02/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person141.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Kira', null, 'Leach', 'Santos', to_date('14/06/1997','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person142.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Monica', 'Mariana', 'Hines', 'Anderson', to_date('11/05/2015','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person143.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Daria', 'Gregoria', 'Barnes', 'Wilkerson', to_date('17/02/1975','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person144.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Tolga', null, 'Burks', 'Woodward', to_date('16/08/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person145.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Mia', null, 'McClean', 'Burks', to_date('18/01/1994','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person146.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jeffrey', 'David', 'Kelley', 'Felix', to_date('02/06/1974','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person147.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jacque', 'Alejandro', 'Kelley', 'Morda', to_date('19/04/1984','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person148.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Olga', 'Paulina', 'Shepard', 'Schwan', to_date('24/05/1991','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person149.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Matthias', 'Isaac', 'Sanford', 'Hill', to_date('11/02/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person150.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Markus', 'Marius', 'Herbert', 'Kenzie', to_date('28/01/1994','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person151.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Edinson', null, 'Braho', 'Curtis', to_date('01/01/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person152.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Eric', null, 'Siuda', 'Lang', to_date('11/12/1994','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person153.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Maddox', 'Jackson', 'Grimes', 'Arellano', to_date('18/02/1994','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person154.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Henrietta', null, 'Shah', 'Curtis', to_date('04/11/1994','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person155.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Kobie', 'Kyle', 'Craig', 'Larssen', to_date('25/08/1974','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person156.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Imani', 'Anderson', 'King', 'Hanson', to_date('14/02/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person157.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Vanessa', 'Alexandra', 'Barrett', 'Fry', to_date('10/06/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person158.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Abdul', 'David', 'Williamson', 'Jones', to_date('26/04/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person159.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Johanna', 'Maria', 'Jones', 'Hammer', to_date('20/10/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person160.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Bea', 'Maxine', 'Nolan', 'Jackson', to_date('26/10/1994','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person161.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Karen', 'Alyssa', 'Weir', 'Cornish', to_date('20/01/1960','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person162.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Kyle', 'Matthews', 'Colton', 'Duggan', to_date('10/09/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person163.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Maximiliano', 'Luke', 'Bloom', 'Randolph', to_date('21/05/1994','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person164.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Katya', null, 'Dumbar', 'Comptom', to_date('26/06/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person165.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Elsa', null, 'Cano', 'Osborne', to_date('04/05/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person166.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Nastya', 'Linda', 'Feeney', 'Hernandez', to_date('11/01/1994','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person167.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Selvin', 'Giovanny', 'Bowler', 'Vickers', to_date('21/05/1994','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person168.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Chelsea', 'Elene', 'Duarte', 'Santos', to_date('25/07/1994','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person169.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Seline', null, 'Pitt', 'Farrell', to_date('21/05/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person170.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Francis', 'Jacob', 'Neville', 'Strong', to_date('21/05/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person171.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Stefania', 'Andrea', 'McMillian', 'Bishop', to_date('17/03/1994','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person172.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jayden', null, 'Snow', 'Hammer', to_date('11/02/1974','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person173.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Antonia', 'Marianna', 'Huber', 'Glover', to_date('20/10/2015','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person174.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Judah', 'Farzana', 'Craig', 'Mayer', to_date('21/05/2016','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person175.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Lewie', null, 'Craig', 'Sanchez', to_date('15/01/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person176.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Brenna', 'Taylor', 'Delgado', 'Rossi', to_date('07/04/1994','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person177.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Rebecca', 'Del Valle', 'Avery', 'Callaghan', to_date('20/08/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person178.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Nana', null, 'Berry', 'Tucker', to_date('14/09/1954','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person179.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Marcus', 'Daniel', 'Ratliff', 'Hamptom', to_date('02/08/2014','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person180.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Brielle', 'Benny', 'Cassidy', 'Hill', to_date('14/08/2016','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person181.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Iqra', null, 'Odom', 'England', to_date('21/05/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person182.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Luciana', 'Cristina', 'Kirkland', 'Muller', to_date('01/05/1964','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person183.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Andrea', 'Alejandra', 'Thompson', 'Davies', to_date('26/12/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person184.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jaime', 'David', 'Mullen', 'Doherty', to_date('18/01/1982','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person185.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Kendall', 'Jenner', 'Richardson', 'Webb', to_date('21/05/1990','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person186.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Tarun', 'Zeeshan', 'Whitley', 'Frost', to_date('11/05/1991','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person187.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Chelsea', null, 'Irving', 'Chang', to_date('30/09/2016','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person188.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jessica', 'Miranda', 'Sinclair', 'Poole', to_date('28/02/1993','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person189.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Rosalinda', null, 'Roman', 'Mejia', to_date('24/01/1995','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person190.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Barbara', 'Zayne', 'Sparrow', 'Ventura', to_date('14/08/1989','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person191.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Emil', 'Lewis', 'Sinclair', 'Dunlap', to_date('25/08/1990','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person192.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Hailey', 'Harleigh', 'Patrick', 'Malone', to_date('20/10/2018','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person193.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Oskar', 'Omar', 'Lennon', 'McCarty', to_date('24/07/2016','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person194.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Jasson', 'Alan', 'Vincent', 'Pena', to_date('28/07/1990','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person195.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Taya', 'Dominika', 'Luna', 'Lamb', to_date('17/06/1994','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person196.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Floyd', 'Bruno', 'Thorpe', 'Hewitt', to_date('20/01/1988','DD/MM/YYYY'), null, 'M'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person197.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Elina', null, 'Suarez', 'Marin', to_date('21/05/1994','DD/MM/YYYY'), null, 'M'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person198.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Giorgia', 'Nimra', 'Arnold', 'Whitney', to_date('20/10/1992','DD/MM/YYYY'), null, 'F'), 15) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person199.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
    INSERT INTO PERSONAS p VALUES (id_persona_seq.nextval, persona(EMPTY_BLOB(), 'Elsie', null, 'Vargas', 'Alcock', to_date('29/03/2016','DD/MM/YYYY'), null, 'F'), 14) RETURNING p.pers.img INTO v_blob;
    v_bfile := BFILENAME('DIR_PEOPLE', 'person200.jpg');
    DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile));
    DBMS_LOB.CLOSE(v_bfile);
END;
/
/* TABLE recintos_salud */
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Hospital Medical Center','Pub', 500, covid_data(356),1);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Health University Hospital','Priv', 200, covid_data(110),2);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Childens and Women Hospital','Pub', 150, covid_data(65),3);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Hospital Johns Hopkins','Pub', 750, covid_data(652),4);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Jackson Memorial Hospital','Pub', 300, covid_data(156),5);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Hospital General New Orleans','Pub', 1500, covid_data(1264),6);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Pediatric Rheumatology Program','Priv', 210, covid_data(127),7);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Robert Wood Johnson Universty Hospital','Pub', 790, covid_data(569),8);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Hospital for Special surgery main hospital','Priv', 530, covid_data(147),9);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Nicklaus Childens Hospital','Pub', 650, covid_data(458),10);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Beth Israel Hospital','Pub', 180, covid_data(141),11);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Hospital Monte Sinai','Priv', 690, covid_data(154),12);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Stanford Medicine','Priv', 910, covid_data(569),13);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Virginia Mason Hospital','Pub', 610, covid_data(298),14);
INSERT INTO recintos_salud VALUES (id_recinto_salud_seq.nextval,'Hospital General Fresno','Pub', 1250, covid_data(945),15);

/* TABLE historico_cierre_fronteras */
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('15/03/2020','DD/MM/YYYY'),to_date('13/05/2020','DD/MM/YYYY')),1);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('25/03/2020','DD/MM/YYYY'),to_date('30/05/2020','DD/MM/YYYY')),2);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('13/03/2020','DD/MM/YYYY'),to_date('13/04/2020','DD/MM/YYYY')),3);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('05/04/2020','DD/MM/YYYY'),null),4);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('15/03/2020','DD/MM/YYYY'),to_date('15/04/2020','DD/MM/YYYY')),5);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('21/04/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')),5);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('01/06/2020','DD/MM/YYYY'),null),5);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('13/03/2020','DD/MM/YYYY'),to_date('07/05/2020','DD/MM/YYYY')),6);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('25/05/2020','DD/MM/YYYY'),to_date('25/06/2020','DD/MM/YYYY')),6);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('07/04/2020','DD/MM/YYYY'),to_date('07/05/2020','DD/MM/YYYY')),7);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('25/03/2020','DD/MM/YYYY'),NULL),8);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('10/04/2020','DD/MM/YYYY'),to_date('25/05/2020','DD/MM/YYYY')),9);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('15/03/2020','DD/MM/YYYY'),to_date('15/04/2020','DD/MM/YYYY')),10);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('21/04/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')),10);
INSERT INTO historico_cierre_fronteras VALUES (id_hist_cierre_seq.nextval,historia(to_date('01/06/2020','DD/MM/YYYY'),null),10);

/* TABLE modelos */
INSERT INTO modelos VALUES (1,'Libre Movilidad');
INSERT INTO modelos VALUES (2,'Cuarentena');
INSERT INTO modelos VALUES (3,'Movilidad Reducida 1-4');
INSERT INTO modelos VALUES (4,'Movilidad Reducida 1-8');

/* TABLE historico_modelos */
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('01/03/2020','DD/MM/YYYY'),to_date('01/04/2020','DD/MM/YYYY')),1,1); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('28/04/2020','DD/MM/YYYY'),to_date('01/06/2020','DD/MM/YYYY')),2,2); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('01/06/2020','DD/MM/YYYY'),to_date('01/07/2020','DD/MM/YYYY')),3,3); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('14/02/2020','DD/MM/YYYY'),null),4,1); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('21/06/2020','DD/MM/YYYY'),null),5,2); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('11/07/2020','DD/MM/YYYY'),null),6,1); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('09/06/2020','DD/MM/YYYY'),null),7,1); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('29/03/2020','DD/MM/YYYY'),null),8,1); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('12/04/2020','DD/MM/YYYY'),to_date('01/06/2020','DD/MM/YYYY')),9,1); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('01/06/2020','DD/MM/YYYY'),null),9,2); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('05/04/2020','DD/MM/YYYY'),to_date('01/06/2020','DD/MM/YYYY')),11,1); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('08/01/2020','DD/MM/YYYY'),to_date('01/02/2020','DD/MM/YYYY')),12,2); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('12/04/2020','DD/MM/YYYY'),null),13,4); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('15/03/2020','DD/MM/YYYY'),null),14,1); 
INSERT INTO historico_modelos VALUES (id_hist_modelo_seq.nextval,historia(to_date('27/03/2020','DD/MM/YYYY'),null),15,4); 

/* TABLE historico_ayuda_humanitaria */
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('28/02/2020','DD/MM/YYYY'),null),100000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('27/03/2020','DD/MM/YYYY'),null),50000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('21/04/2020','DD/MM/YYYY'),null),120000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('06/03/2020','DD/MM/YYYY'),null),300000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('19/05/2020','DD/MM/YYYY'),null),1000000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('27/06/2020','DD/MM/YYYY'),null),1200000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('14/05/2020','DD/MM/YYYY'),null),50000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('27/04/2020','DD/MM/YYYY'),null),650000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('04/06/2020','DD/MM/YYYY'),null),125000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('15/03/2020','DD/MM/YYYY'),null),25000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('27/04/2020','DD/MM/YYYY'),null),10000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('07/03/2020','DD/MM/YYYY'),null),800000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('09/04/2020','DD/MM/YYYY'),null),1000000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('17/03/2020','DD/MM/YYYY'),null),750000,1,10);
INSERT INTO historico_ayuda_humanitaria VALUES (id_hist_ayuda_seq.nextval,historia(to_date('24/04/2020','DD/MM/YYYY'),null),70000,1,10);

/* TABLE historico_viajes */
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('23/04/2020','DD/MM/YYYY'),to_date('23/04/2020','DD/MM/YYYY')),953842,1,6,5);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('15/06/2020','DD/MM/YYYY'),to_date('15/06/2020','DD/MM/YYYY')),598426,1,11,2);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('28/02/2020','DD/MM/YYYY'),to_date('01/03/2020','DD/MM/YYYY')),984265,3,1,5);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('23/05/2020','DD/MM/YYYY'),to_date('23/05/2020','DD/MM/YYYY')),584637,3,6,14);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('07/02/2020','DD/MM/YYYY'),to_date('07/02/2020','DD/MM/YYYY')),125487,2,3,5);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('07/03/2020','DD/MM/YYYY'),to_date('08/03/2020','DD/MM/YYYY')),965447,2,7,15);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('14/01/2020','DD/MM/YYYY'),to_date('14/01/2020','DD/MM/YYYY')),487556,5,10,6);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('11/05/2020','DD/MM/YYYY'),to_date('11/05/2020','DD/MM/YYYY')),695844,6,7,12);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('09/04/2020','DD/MM/YYYY'),to_date('09/04/2020','DD/MM/YYYY')),112254,8,8,3);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('13/04/2020','DD/MM/YYYY'),to_date('13/04/2020','DD/MM/YYYY')),458962,9,12,8);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('28/04/2020','DD/MM/YYYY'),to_date('28/04/2020','DD/MM/YYYY')),156687,10,7,8);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('27/05/2020','DD/MM/YYYY'),to_date('27/05/2020','DD/MM/YYYY')),336584,12,4,7);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('15/04/2020','DD/MM/YYYY'),to_date('15/04/2020','DD/MM/YYYY')),944526,12,12,4);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('20/02/2020','DD/MM/YYYY')),452147,14,15,1);
INSERT INTO historico_viajes VALUES (id_hist_viajes_seq.nextval,historia(to_date('01/03/2020','DD/MM/YYYY'),to_date('01/03/2020','DD/MM/YYYY')),568465,5,1,5);

/* TABLE historico_tratamiento */
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('12/03/2020','DD/MM/YYYY'),to_date('21/04/2020','DD/MM/YYYY')),1,1);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('30/04/2020','DD/MM/YYYY'),to_date('25/05/2020','DD/MM/YYYY')),2,1);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('04/06/2020','DD/MM/YYYY'),to_date('10/07/2020','DD/MM/YYYY')),4,3);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('16/05/2020','DD/MM/YYYY'),null),7,3);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('28/03/2020','DD/MM/YYYY'),null),9,5);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('15/02/2020','DD/MM/YYYY'),to_date('11/04/2020','DD/MM/YYYY')),11,5);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('07/04/2020','DD/MM/YYYY'),to_date('10/05/2020','DD/MM/YYYY')),13,6);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('09/04/2020','DD/MM/YYYY'),null),14,7);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('19/06/2020','DD/MM/YYYY'),to_date('01/07/2020','DD/MM/YYYY')),16,7);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('05/05/2020','DD/MM/YYYY'),to_date('20/06/2020','DD/MM/YYYY')),17,7);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('07/06/2020','DD/MM/YYYY'),null),19,10);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('17/04/2020','DD/MM/YYYY'),to_date('28/05/2020','DD/MM/YYYY')),20,10);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('28/03/2020','DD/MM/YYYY'),null),24,9);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('24/02/2020','DD/MM/YYYY'),to_date('01/04/2020','DD/MM/YYYY')),27,9);
INSERT INTO historico_tratamiento VALUES (id_hist_tratamiento_seq.nextval,historia(to_date('20/04/2020','DD/MM/YYYY'),null),26,8);

/* TABLE A_I */
INSERT INTO A_I VALUES (120,1,1);
INSERT INTO A_I VALUES (100,2,1);
INSERT INTO A_I VALUES (210,3,1);
INSERT INTO A_I VALUES (150,4,1);
INSERT INTO A_I VALUES (250,1,2);
INSERT INTO A_I VALUES (100,2,2);
INSERT INTO A_I VALUES (350,5,2);
INSERT INTO A_I VALUES (90,6,2);
INSERT INTO A_I VALUES (80,7,3);
INSERT INTO A_I VALUES (250,10,3);
INSERT INTO A_I VALUES (190,11,4);
INSERT INTO A_I VALUES (300,12,4);
INSERT INTO A_I VALUES (410,10,4);
INSERT INTO A_I VALUES (140,7,7);
INSERT INTO A_I VALUES (210,8,7);

/* TABLE H_I */
INSERT INTO H_I VALUES (120,1,11);
INSERT INTO H_I VALUES (100,2,11);
INSERT INTO H_I VALUES (210,3,11);
INSERT INTO H_I VALUES (150,4,11);
INSERT INTO H_I VALUES (250,1,2);
INSERT INTO H_I VALUES (100,2,2);
INSERT INTO H_I VALUES (350,5,2);
INSERT INTO H_I VALUES (90,6,2);
INSERT INTO H_I VALUES (80,7,3);
INSERT INTO H_I VALUES (250,10,3);
INSERT INTO H_I VALUES (190,11,5);
INSERT INTO H_I VALUES (300,12,5);
INSERT INTO H_I VALUES (410,10,5);
INSERT INTO H_I VALUES (140,7,8);
INSERT INTO H_I VALUES (210,8,8);

/* TABLE E_P */
INSERT INTO E_P VALUES (1,1);
INSERT INTO E_P VALUES (2,1);
INSERT INTO E_P VALUES (3,2);
INSERT INTO E_P VALUES (4,2);
INSERT INTO E_P VALUES (5,3);
INSERT INTO E_P VALUES (6,3);
INSERT INTO E_P VALUES (7,6);
INSERT INTO E_P VALUES (8,11);
INSERT INTO E_P VALUES (9,10);
INSERT INTO E_P VALUES (10,10);
INSERT INTO E_P VALUES (11,15);
INSERT INTO E_P VALUES (12,15);
INSERT INTO E_P VALUES (13,7);
INSERT INTO E_P VALUES (14,7);
INSERT INTO E_P VALUES (15,8);

/* TABLE C_HV */
INSERT INTO C_HV VALUES (1,18);
INSERT INTO C_HV VALUES (1,16);
INSERT INTO C_HV VALUES (3,16);
INSERT INTO C_HV VALUES (3,18); 
INSERT INTO C_HV VALUES (5,17);
INSERT INTO C_HV VALUES (6,22);
INSERT INTO C_HV VALUES (7,6);
INSERT INTO C_HV VALUES (7,7);
INSERT INTO C_HV VALUES (10,6);
INSERT INTO C_HV VALUES (10,5);
INSERT INTO C_HV VALUES (11,6);
INSERT INTO C_HV VALUES (11,7);
INSERT INTO C_HV VALUES (8,10);
INSERT INTO C_HV VALUES (2,1);
INSERT INTO C_HV VALUES (13,23);


/* TABLE P_HV */
INSERT INTO P_HV VALUES (1,6);
INSERT INTO P_HV VALUES (1,8);
INSERT INTO P_HV VALUES (3,3);
INSERT INTO P_HV VALUES (3,2);
INSERT INTO P_HV VALUES (5,9);
INSERT INTO P_HV VALUES (6,3);
INSERT INTO P_HV VALUES (7,15);
INSERT INTO P_HV VALUES (7,13);
INSERT INTO P_HV VALUES (10,10);
INSERT INTO P_HV VALUES (10,4);
INSERT INTO P_HV VALUES (11,13);
INSERT INTO P_HV VALUES (11,3);
INSERT INTO P_HV VALUES (8,1);
INSERT INTO P_HV VALUES (2,2);
INSERT INTO P_HV VALUES (13,12);

/* TABLE P_PAT */
INSERT INTO P_PAT VALUES (7,10);
INSERT INTO P_PAT VALUES (4,13);
INSERT INTO P_PAT VALUES (7,9);
INSERT INTO P_PAT VALUES (3,13);
INSERT INTO P_PAT VALUES (6,12);
INSERT INTO P_PAT VALUES (2,8);
INSERT INTO P_PAT VALUES (10,9);
INSERT INTO P_PAT VALUES (15,11);
INSERT INTO P_PAT VALUES (10,14);
INSERT INTO P_PAT VALUES (1,10);
INSERT INTO P_PAT VALUES (8,4);
INSERT INTO P_PAT VALUES (15,13);
INSERT INTO P_PAT VALUES (11,12);
INSERT INTO P_PAT VALUES (8,6);
INSERT INTO P_PAT VALUES (1,8);
INSERT INTO P_PAT VALUES (150,1);
INSERT INTO P_PAT VALUES (150,4);
INSERT INTO P_PAT VALUES (150,5);
INSERT INTO P_PAT VALUES (151,4);
INSERT INTO P_PAT VALUES (152,5);
INSERT INTO P_PAT VALUES (153,1);
INSERT INTO P_PAT VALUES (153,7);
INSERT INTO P_PAT VALUES (154,10);
INSERT INTO P_PAT VALUES (154,9);
INSERT INTO P_PAT VALUES (155,1);
INSERT INTO P_PAT VALUES (155,2);
INSERT INTO P_PAT VALUES (156,6);
INSERT INTO P_PAT VALUES (157,9);
INSERT INTO P_PAT VALUES (158,11);
INSERT INTO P_PAT VALUES (159,1);
INSERT INTO P_PAT VALUES (159,2);
INSERT INTO P_PAT VALUES (159,3);
INSERT INTO P_PAT VALUES (160,1);
INSERT INTO P_PAT VALUES (160,2);
INSERT INTO P_PAT VALUES (161,1);
INSERT INTO P_PAT VALUES (161,2);
INSERT INTO P_PAT VALUES (162,4);
INSERT INTO P_PAT VALUES (163,4);
INSERT INTO P_PAT VALUES (164,7);
INSERT INTO P_PAT VALUES (165,9);


/* TABLE P_S */
INSERT INTO P_S VALUES (11,9,to_date('18/02/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (4,1,to_date('03/02/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (2,12,to_date('20/03/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (4,7,null);
INSERT INTO P_S VALUES (12,6,to_date('06/04/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (15,2,to_date('01/04/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (6,9,to_date('30/01/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (15,14,to_date('26/04/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (6,15,null);
INSERT INTO P_S VALUES (10,13,to_date('15/01/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (1,11,to_date('17/02/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (9,13,null);
INSERT INTO P_S VALUES (5,10,null);
INSERT INTO P_S VALUES (9,14,to_date('25/03/2020','DD/MM/YYYY'));
INSERT INTO P_S VALUES (8,14,to_date('04/03/2020','DD/MM/YYYY'));

/* TABLE P_PROV */
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,1,8,15.24,5.12,0,historia(to_date('12/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,2,9,25.12,15.98,0,historia(to_date('12/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,3,7,75.24,50.65,1,historia(to_date('12/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,4,5,52.36,30.45,1,historia(to_date('12/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,5,8,120.15,60.25,1,historia(to_date('12/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,6,15,80.25,50.36,0,historia(to_date('15/04/2020','DD/MM/YYYY'),to_date('16/04/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,7,7,24.21,14.25,1,historia(to_date('15/04/2020','DD/MM/YYYY'),to_date('16/04/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,8,4,45.65,20.36,2,historia(to_date('15/04/2020','DD/MM/YYYY'),to_date('16/04/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,9,12,54.26,26.45,0,historia(to_date('15/04/2020','DD/MM/YYYY'),to_date('16/04/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,12,9,33.71,10.89,1,historia(to_date('15/04/2020','DD/MM/YYYY'),to_date('16/04/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,13,2,76.94,41.09,0,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,14,5,80.19,45.32,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,15,9,20.64,9.91,0,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,16,3,0.11,0.1,4,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,17,8,60.39,30.11,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,18,11,50.10,25.60,3,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,19,5,210,500,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,20,4,55.3,31,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,21,7,43.2,4.2,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,22,8,21.5,11.5,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,23,9,1.1,0.3,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,24,1,100,93,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,25,3,4.3,2,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,26,4,24.2,11.1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,27,6,11.2,4.2,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,28,5,12,5,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,29,1,44.2,32,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,30,2,101,21,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,31,3,32.4,32.5,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,32,5,210,500,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,33,7,210,500,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,34,4,210,500,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,35,5,210,500,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,36,9,210,500,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,37,8,210,500,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,38,7,111.2,43.2,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,39,6,41.3,21.1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,40,5,41.4,32,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,41,5,201,11.1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,42,5,22,11,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,43,4,3,1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,44,3,3.2,1.1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,45,2,45.2,32.1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,46,1,43.1,5,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,47,5,2.3,1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,48,3,53.2,31.1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,49,2,93.2,4.3,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,50,6,21,11,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,51,8,43.2,11,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,52,6,21,5,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,53,3,1,1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,54,4,53.1,32.1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,55,6,54.1,19.3,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,56,7,53.3,42.1,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,57,5,400,200,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,58,5,54.2,11.5,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,59,5,603,500,1,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,60,5,604.3,204.2,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,61,5,210,500,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,62,5,210,500,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,63,5,210,500,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,64,5,210,500,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,65,1,210,500,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,66,2,54.2,32.1,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,67,3,10.3,4,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,68,4,8,2,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,69,7,9,1,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,70,8,53.5,43.1,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,71,9,304.2,100.3,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,72,1,94.2,53.2,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,73,2,59.4,22.2,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,74,5,53.1,11,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,75,3,53.2,33.3,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,76,2,159,111,1,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,77,1,53.2,31.3,2,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,78,6,65.4,23.3,2,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,79,3,65.2,32.3,2,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,80,1,76.3,32.4,2,historia(to_date('19/12/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,81,3,43.4,23.3,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,82,4,54.2,11.2,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,83,5,43.2,33,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,84,6,54.2,31.1,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,85,7,65.2,50,3,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,86,3,64.2,32,3,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,87,2,55.2,11,3,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,88,4,66.3,33.1,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,89,3,54.2,12.1,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,90,6,45.3,33.2,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,91,3,655,500,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,92,2,942,500,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,93,1,452,200,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,94,5,210,500,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,95,5,210,500,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,96,5,210,500,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,97,5,210,500,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,98,5,210,500,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,99,5,210,500,3,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,100,5,54.2,10,3,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,101,5,54.1,43,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,102,5,76.3,34.2,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,103,5,65.3,52.3,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,104,4,99.4,83.3,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,105,3,54.4,44.3,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,106,3,65.5,35.4,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,107,3,76.4,43.3,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,108,3,65.3,33,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,109,3,21,4,2,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,110,3,53.5,24.4,3,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,111,3,101,54.3,1,historia(to_date('19/11/2019','DD/MM/YYYY'),to_date('19/12/2019','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,112,2,150.4,100,2,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,113,2,53.4,10.3,2,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,114,2,53.3,34.3,2,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,115,2,66.5,11,2,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,116,2,400,200,2,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,117,8,785,500,2,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,118,8,985,500,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,119,8,500,500,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,120,8,542.3,500,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,121,8,65.3,50,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,122,8,76.4,50,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,123,5,710,453.2,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,124,4,210,500,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,125,3,210,500,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,126,3,109.3,102.4,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,127,3,101.1,100,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,128,1,210,500,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,129,1,65.3,23.1,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,130,1,21.4,45.3,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,131,1,210,500,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,132,1,210,24.5,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,133,1,54.3,23.2,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,134,1,54.2,33.3,1,historia(to_date('20/01/2020','DD/MM/YYYY'),to_date('25/01/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,135,1,54.3,33.2,3,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,136,1,210,500,3,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,137,2,210,500,3,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,138,4,210,500,3,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,139,6,210,110.3,2,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,140,6,210,500,2,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,141,6,210,500,2,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,142,6,210,500,2,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,143,6,653.3,500,1,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,144,6,210,500,1,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,145,9,210,500,1,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,146,9,210,500,1,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,147,9,210,500,1,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,148,8,210,500,1,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,149,6,210,500,1,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,150,6,67.5,32.3,1,historia(to_date('20/02/2020','DD/MM/YYYY'),to_date('23/02/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,151,6,76.4,32.1,1,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,152,4,66.3,11,1,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,153,5,55.4,11,1,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,154,3,654,300,1,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,155,4,65.3,23.2,1,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,156,3,54.3,30.1,1,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,157,4,65.4,50,1,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,158,4,54.3,20.4,1,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,159,4,54.3,32,3,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,160,4,210,500,3,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,161,4,210,500,3,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,162,4,210,500,3,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,163,5,210,500,3,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,164,4,210,500,3,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,165,2,210,500,3,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,166,1,210,500,3,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,167,1,210,500,4,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,168,1,210,500,4,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,169,1,210,500,4,historia(to_date('03/03/2020','DD/MM/YYYY'),to_date('13/03/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,170,1,210,500,4,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,171,3,210,500,4,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,172,3,210,500,4,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,173,3,210,500,2,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,174,3,210,500,2,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,175,3,700,500,2,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,176,3,652,500,2,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,177,3,102,78,2,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,178,4,20,10,2,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,179,4,65,32,2,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));
INSERT INTO P_PROV VALUES (id_p_prov_seq.nextval,180,4,185,85.4,2,historia(to_date('20/05/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')));


/* TABLE infectados_covid */
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('12/03/2020','DD/MM/YYYY'),to_date('21/04/2020','DD/MM/YYYY')),'I',1,1,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('30/04/2020','DD/MM/YYYY'),to_date('25/05/2020','DD/MM/YYYY')),'I',2,2,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('04/06/2020','DD/MM/YYYY'),to_date('10/07/2020','DD/MM/YYYY')),'M',4,3,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('04/06/2020','DD/MM/YYYY'),to_date('10/07/2020','DD/MM/YYYY')),'C',7,4,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('28/03/2020','DD/MM/YYYY'),null),'I',9,5,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('15/02/2020','DD/MM/YYYY'),to_date('11/04/2020','DD/MM/YYYY')),'M',11,6,10);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('07/04/2020','DD/MM/YYYY'),to_date('10/05/2020','DD/MM/YYYY')),'C',13,7,10);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('09/04/2020','DD/MM/YYYY'),null),'I',14,8,1);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('19/06/2020','DD/MM/YYYY'),to_date('01/07/2020','DD/MM/YYYY')),'I',16,9,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('05/05/2020','DD/MM/YYYY'),to_date('20/06/2020','DD/MM/YYYY')),'C',17,10,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('07/06/2020','DD/MM/YYYY'),null),'I',19,11,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('17/04/2020','DD/MM/YYYY'),to_date('28/05/2020','DD/MM/YYYY')),'C',20,12,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('28/03/2020','DD/MM/YYYY'),null),'I',24,13,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('24/02/2020','DD/MM/YYYY'),to_date('01/04/2020','DD/MM/YYYY')),'M',7,14,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('20/04/2020','DD/MM/YYYY'),null),'I',26,15,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('02/05/2020','DD/MM/YYYY'),to_date('30/05/2020','DD/MM/YYYY')),'I',3,null,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('17/03/2020','DD/MM/YYYY'),to_date('21/05/2020','DD/MM/YYYY')),'C',6,null,12);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('14/04/2020','DD/MM/YYYY'),to_date('24/06/2020','DD/MM/YYYY')),'C',12,null,10);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('19/01/2020','DD/MM/YYYY'),to_date('27/02/2020','DD/MM/YYYY')),'M',15,null,1);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('25/06/2020','DD/MM/YYYY'),null),'I',152,null,1);
INSERT INTO INFECTADOS_COVID VALUES (id_infectado_seq.nextval,historia(to_date('25/06/2020','DD/MM/YYYY'),null),'I',187,null,1);