SAP HANA SQL创建trigger

trigger很常用，无论是在HANA还是在Oracle中

请直接看代码

 CREATE TABLE TARGET ( A INT);CREATE TABLE SAMPLE ( A INT);CREATE TRIGGER TEST_TRIGGER_WHILE_UPDATEAFTER UPDATE ON TARGETBEGINDECLARE found INT := 1;DECLARE val INT := 1;WHILE :found <> 0 DOSELECT count(*) INTO found FROM sample WHERE a = :val;IF :found = 0 THENINSERT INTO sample VALUES(:val);END IF;val := :val + 1;END WHILE;END;