triggers删除问题与partition by
我将table中的某一笔资料删除后
想要在triggers中将最靠近(删除的那笔资料),的某个栏位值变成null
为什么triggers中却无法使用partition by呢??
程式码如下
IF DELETING THEN
UPDATE aaa D
SET D.a =''
WHERE D.b = (
SELECT b FROM (select T.*,row_number() over (partition by dep order by date_1,time_1 DESC) P from aaa t )→错误会在这
WHERE dep = :OLD.dep
WHERE a = 'n'
AND P = 1)
AND D.date_1 = (
SELECT date_1 FROM (select T.*, row_number() over (partition by dep order by date_1,time_1 DESC) NUM from aaa t)→错误会在这
WHERE dep = :OLD.dep
AND a = 'n'
AND NUM = 1);
END IF;
table资料如下
dep date_1 time_1 b
a 20110512 12:30 y
a 20110512 14:40 y
a 20100530 13:00 →我把这笔删除后,系统会把20110512,4:40这笔的b栏位改成null
请问在triggers中我该如何修改这段程式码,或是有更精简的方法可以让我完成我需要的资料,拜托了谢谢..