-- Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='FKCTACOMENCOD'; delete from tConstraintsResultado where constraintname='FKIDITIPCOMEN'; delete from tConstraintsResultado where constraintname='FKTIPCOMENCOD'; delete from tConstraintsResultado where constraintname='FKTIPCOMENID'; delete from tConstraintsResultado where constraintname='IPKTIPCOMEN'; delete from tConstraintsResultado where constraintname='IPKTIPCOMENID'; -- Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='FKCTACOMENCOD'; delete from tConstraintsResultadoId where constraintname='FKIDITIPCOMEN'; delete from tConstraintsResultadoId where constraintname='FKTIPCOMENCOD'; delete from tConstraintsResultadoId where constraintname='FKTIPCOMENID'; delete from tConstraintsResultadoId where constraintname='IPKTIPCOMEN'; delete from tConstraintsResultadoId where constraintname='IPKTIPCOMENID'; -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('FKCTACOMENCOD','2291','505339'); insert into tConstraintsResultadoId values('FKIDITIPCOMEN','2291','505340'); insert into tConstraintsResultadoId values('FKTIPCOMENCOD','2291','505341'); insert into tConstraintsResultadoId values('FKTIPCOMENID','2291','505342'); insert into tConstraintsResultadoId values('IPKTIPCOMEN','1','505343'); insert into tConstraintsResultadoId values('IPKTIPCOMENID','1','505344'); -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','FKCTACOMENCOD',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'),'NO EXISTE REFERENCIA DE TCUENTACOMENTARIOS EN TCODIGOSCOMENTARIOID'); insert into tConstraintsResultado values('ES','FKIDITIPCOMEN',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'),'NO EXISTE REFERENCIA DE TTIPOSCOMENTARIO EN TIDIOMASID'); insert into tConstraintsResultado values('ES','FKTIPCOMENCOD',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'),'NO EXISTE REFERENCIA DE TCODIGOSCOMENTARIOID EN TTIPOSCOMENTARIOID'); insert into tConstraintsResultado values('ES','FKTIPCOMENID',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'),'NO EXISTE REFERENCIA DE TTIPOSCOMENTARIO EN TTIPOSCOMENTARIOID'); insert into tConstraintsResultado values('ES','IPKTIPCOMEN',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'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TTIPOSCOMENTARIO'); insert into tConstraintsResultado values('ES','IPKTIPCOMENID',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'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TTIPOSCOMENTARIOID'); commit; -- Done.