Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER tr_b_insert_prom_observacion
- after
- INSERT OR UPDATE ON matricula
- FOR EACH ROW
- DECLARE
- promedio NUMBER := 0;
- observacion VARCHAR(70):='';
- BEGIN
- promedio := (:NEW.nota_parcial1+:NEW.nota_parcial2)/2;
- IF promedio >= 15 THEN
- observacion:='Aprobado';
- ELSE
- observacion :='Reprobado';
- END IF;
- UPDATE matricula SET PROMEDIO = promedio, OBSERVACION_MATRICULA = observacion WHERE ID_ASIGNATURA = :NEW.id_asignatura AND ID_ESTUDIANTE = :NEW.id_estudiante;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement