triggerSQL

CREATE OR REPLACE TRIGGER restoreUsersTrigger
after INSERT OR DELETE OR UPDATE ON USERS
FOR each ROW

DECLARE
    request varchar2(200);

BEGIN

    IF inserting THEN
        request := 'INSERT INTO USERS@bibouba VALUES (' || :NEW.id || ',"' || :NEW.name || '","' || :NEW.surname || '","' || :NEW.login || '","' || :NEW.pass || '");';

        INSERT INTO TEMPREQUESTS VALUES (temprequests_sec.NEXTVAL, request);

    END IF;

END;