spool DatosCamposParcial.log set Define "!" set feedback off set define off prompt Deleting TCAMPOSCONSULTABLES... delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TESTADOCUENTA'); prompt Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TESTADOCUENTA'; prompt Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(2693001,'TESTADOCUENTA','CCUENTA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2693002,'TESTADOCUENTA','DESCRIPCIONTRANSACCION',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(60)',60,0,'0'); insert into tCamposConsultablesId values(2693003,'TESTADOCUENTA','FCONTABLE',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2693004,'TESTADOCUENTA','FREAL',5,null,null,'S',null,'0','1','','0','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2693005,'TESTADOCUENTA','NUMERODOCUMENTO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2693006,'TESTADOCUENTA','SALDO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2693007,'TESTADOCUENTA','VALORCREDITOCUENTA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2693008,'TESTADOCUENTA','VALORDEBITOCUENTA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2693009,'TESTADOCUENTA','CPERSONA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2693010,'TESTADOCUENTA','NUMEROMENSAJE',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(2693011,'TESTADOCUENTA','SECUENCIA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(2693012,'TESTADOCUENTA','SALDOBLOQUEADO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2693013,'TESTADOCUENTA','SALDODIFERIDO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2693014,'TESTADOCUENTA','SALDODISPONIBLE',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2693015,'TESTADOCUENTA','SALDOFECHA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2693016,'TESTADOCUENTA','SALDOPIGNORADO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2693017,'TESTADOCUENTA','SALDOPROMEDIOMENSUAL',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); prompt Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693001,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'),'Numero de cuenta '); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693002,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'),'Decripcion de la transaccion'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693003,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'),'Fecha contable del estado de cuenta'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693004,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'),'Fecha real del movimiento'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693005,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'),'Numero de documento de la transaccion'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693006,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'),'Saldo de la cuenta'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693007,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'),'Valor del movimiento de credito'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693008,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'),'Valor del movimiento de debito'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693009,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'),'Codigo de persona'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693010,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'),'Numero de mensaje del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693011,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'),'Numero de consecutivo para el reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693012,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'),'Saldo Bloqueado'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693013,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'),'Saldo Diferido'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693014,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'),'Saldo disponible'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693015,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'),'Saldo a la Fecha'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693016,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'),'Saldo Pignorado'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693017,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'),'Saldo Promedio Mensual'); commit; set Define "&" set feedback on prompt Done. spool off