-- Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='CKTASAANTICIPADACP'; delete from tConstraintsResultado where constraintname='CKTASAANTICIPADAPCP'; delete from tConstraintsResultado where constraintname='CKTASAANTICIPADASOLCP'; -- Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='CKTASAANTICIPADACP'; delete from tConstraintsResultadoId where constraintname='CKTASAANTICIPADAPCP'; delete from tConstraintsResultadoId where constraintname='CKTASAANTICIPADASOLCP'; -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('CKTASAANTICIPADACP','2290','505286'); insert into tConstraintsResultadoId values('CKTASAANTICIPADAPCP','2290','505287'); insert into tConstraintsResultadoId values('CKTASAANTICIPADASOLCP','2290','505288'); -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','CKTASAANTICIPADACP',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'FUERA DE LOS VALORES PERMITIDOS PARA TCUENTAPLAZO.TASAANTICIPADA = upper(TASAANTICIPADA)'); insert into tConstraintsResultado values('ES','CKTASAANTICIPADAPCP',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'FUERA DE LOS VALORES PERMITIDOS PARA TPRODUCTOCAPTACIONESPLAZO.TASAANTICIPADA = upper(TASAANTICIPADA) and TASAANTICIPADA'); insert into tConstraintsResultado values('ES','CKTASAANTICIPADASOLCP',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'FUERA DE LOS VALORES PERMITIDOS PARA TSOLICITUDPLAZO.TASAANTICIPADA = upper(TASAANTICIPADA) and TASAANTICIPADA in (1,0)'); commit; -- Done.