lunes, 2 de mayo de 2011

Creando triggers

CREATE TRIGGER trig1
AFTER INSERT ON T4
REFERENCING NEW AS newRow
FOR EACH ROW
WHEN (newRow.a <= 10)
BEGIN
INSERT INTO T5 VALUES(:newRow.b, :newRow.a);
END trig1;

SELECT * FROM T5

No hay comentarios.:

Publicar un comentario