delete_ticket_tigger.sql

来自「该票务系统包括的功能有网上订票、历史订阅纪录查询、近期上映影片推荐和查询和统计报」· SQL 代码 · 共 12 行

create or replace trigger delete_section_trigger after delete on show
referencing old as old
for each row
begin
	delete from bookRecord
	where ticket_id in(
						select ticket_id from ticket
						where ticket.section= :old.section and ticket.sold='1') ;
	delete from ticket
	where section= :old.section;
end;