Forum Stats

  • 3,826,078 Users
  • 2,260,593 Discussions
  • 7,896,782 Comments

Discussions

Triggers with count(*)

Havva
Havva Member Posts: 5 Green Ribbon
edited Apr 18, 2022 5:50PM in APEX Discussions

Is there a way to use a trigger and get count of the table in the after trigger? I want to update the x table , when I am deleting the data from y table. The two table have bookid in common. I want to count how many books left on y table after I deleted data and if there is still books in y table I want to update x table's YESNO column = YES. If no data left I want to update YESNO column = NO.

Tagged:

Answers