lab10

DESCRIBE note;

DROP TABLE activityLogs_note;
/

CREATE TABLE activityLogs_note (
    idNota NUMBER(38, 0),
    oldNota NUMBER(2),
    newNota NUMBER(2),
    operation VARCHAR(20),
    timeOfOperation TIMESTAMP,
    actor VARCHAR(50)
)
/

DESCRIBE activityLogs_note;



CREATE OR REPLACE TRIGGER Watcher_insert
BEFORE INSERT ON note
FOR EACH ROW
DECLARE
v_currTime TIMESTAMP;
v_currUser VARCHAR(50);
BEGIN
    SELECT TIMESTAMP INTO v_currTime FROM DUAL;
    SELECT USER INTO v_currUser FROM DUAL;

    DBMS_OUTPUT.PUT_LINE(v_currTime);

    INSERT INTO activityLogs_note (idNota, oldNota,
        newNota, operation, timeOfOperation, actor)
    VALUES
        (id, NULL, valoare, 'INSERT',
        v_currTime, v_currUser);


END;
/