Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // CREACIÓN DE TABLA.
- CREATE TABLE auditoria (
- nombre_usuario VARCHAR2(18),
- modificacion VARCHAR2(50),
- hora VARCHAR2(10),
- fecha DATE,
- clave_primaria_calle VARCHAR2(30) DEFAULT NULL,
- clave_primera_numero NUMBER(3) DEFAULT NULL
- );
- // TRIGGER CREADO CORRECTAMENTE.
- CREATE OR REPLACE TRIGGER ejer_auditoria
- after INSERT OR DELETE OR UPDATE ON vivienda
- FOR each ROW
- DECLARE
- v_hora auditoria.hora%TYPE;
- BEGIN
- IF inserting THEN
- INSERT INTO auditoria VALUES (USER, 'Insercion / Insert', TO_CHAR(SYSDATE, 'HH24:MI:SS'), SYSDATE, :NEW.calle, :NEW.numero);
- END IF;
- IF deleting THEN
- INSERT INTO auditoria VALUES (USER, 'Borrado / Delete', TO_CHAR(SYSDATE, 'HH24:MI:SS'), SYSDATE, :old.calle, :old.numero);
- END IF;
- IF updating THEN
- INSERT INTO auditoria VALUES (USER, 'Actualizacion / Update', TO_CHAR(SYSDATE, 'HH24:MI:SS'), SYSDATE, :NEW.calle, :NEW.numero);
- END IF;
- END;
- /
- // TRIGGER CREADO CORRECTAMENTE 2.
- CREATE OR REPLACE TRIGGER ejer_auditoria_2
- after INSERT OR DELETE OR UPDATE ON bloquecasas
- DECLARE
- v_hora auditoria.hora%TYPE;
- BEGIN
- IF inserting THEN
- INSERT INTO auditoria VALUES (USER, 'Insercion / Insert', TO_CHAR(SYSDATE, 'HH24:MI:SS'), SYSDATE, NULL, NULL);
- END IF;
- IF deleting THEN
- INSERT INTO auditoria VALUES (USER, 'Borrado / Delete', TO_CHAR(SYSDATE, 'HH24:MI:SS'), SYSDATE, NULL, NULL);
- END IF;
- IF updating THEN
- INSERT INTO auditoria VALUES (USER, 'Actualizacion / Update', TO_CHAR(SYSDATE, 'HH24:MI:SS'), SYSDATE, NULL, NULL);
- END IF;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement