SISTEMAS
Page tree

Versions Compared

Old Version 2

changes.mady.by.user Sistemas

Saved on

compared with

New Version Current

changes.mady.by.user Sistemas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themeMidnight
INSERT INTO creditopy.audit_baja_autoriz
SELECT b.numero_autorizacion,
       b.tarjeta,
       b.monto_compra,
       b.numero_comercio,
       b.baja,
       SYSDATE fec_upd,
       'CEIBOM' USUARIO
from creditopy.autorizaciones b
where b.numero_autorizacion=518263
  and b.monto_compra=3
  and b.tarjeta = '18127CFF238A4D98';

CONSULTAS UTILES

Code Block
languagesql
themeMidnight
select * from creditopy.autorizaciones a
where a.numero_autorizacion=518263
  and a.monto_compra=3
  and a.tarjeta = '18127CFF238A4D98';

select * from creditopy.autorizaciones a
where A.BAJA = 'B'
  AND A.FECHA>'01062022';
    
SELECT * FROM creditopy.audit_baja_autoriz
WHERE FEC_UPD>'01062022'
ORDER BY FEC_UPD DESC;