DESCRIBE informesFallos;

SELECT * FROM suministrar;

SELECT * FROM informesFallos;

SELECT * FROM totalFallos;

SELECT * FROM sumNoValidos;

DESCRIBE USER_SOURCE;

SELECT * FROM user_source ORDER BY TYPE, name, line;

DESCRIBE USER_TRIGGERS;

-- Ver todos los disparadores y su estado
SELECT TRIGGER_NAME, STATUS FROM USER_TRIGGERS;

-- ver todo de un disparador
SELECT * FROM USER_TRIGGERS WHERE TRIGGER_NAME =UPPER('testMaxFallos');

-- ver el cuerpo de un disparador
SELECT TRIGGER_BODY FROM USER_TRIGGERS WHERE TRIGGER_NAME ='TESTMAXFALLOS';

-- ver la descripción de un disparador
SELECT DESCRIPTION FROM USER_TRIGGERS WHERE TRIGGER_NAME = UPPER('testMaxFallos');

-- activar todos los disparadores asociados a una tabla:
ALTER TABLE informesFallos ENABLE ALL TRIGGERS;

-- desactivar todos los disparadores asociados a una tabla:
ALTER TABLE informesFallos DISABLE ALL TRIGGERS;

-- activar un disparador específico:
ALTER TRIGGER testMaxFallos ENABLE;

-- desactivar un disparador específico:
ALTER TRIGGER testMaxFallos DISABLE;

EXECUTE informarFallo (94, 96, 'fallo del fleje');
EXECUTE informarFallo (94, 96, 'rotura solapa');
EXECUTE informarFallo (94, 96, 'fisura extraña');

BEGIN
  EXECUTE informarFallo (94, 96, 'fallo del fleje');
  EXECUTE informarFallo (94, 96, 'rotura solapa');
END;
/

DELETE FROM informesFallos;

INSERT INTO informesFallos VALUES (94, 96, SYSDATE, 'fallo del fleje');

DELETE FROM totalFallos;

EXECUTE actualizarTotalFallos;

DELETE FROM sumNoValidos WHERE (clvProv, clvPieza) IN ((96, 94));

DELETE FROM suministrar WHERE (clvProv, clvPieza) IN ((96, 94));

INSERT INTO suministrar VALUES (96, 94);

DROP TRIGGER informeFallo_BI;
DROP TRIGGER testSuministro_BI;


ROLLBACK;
COMMIT;