Re: Issues with converting update command to trigger
A Trigger can't issue an Insert or Update on the table for which it's defined (because it could loop forever).
Is this what you mean?
CREATE TRIGGER add_desc AFTER insert on telemetry_log FOR EACH ROW
set new.device_desc = ( select device_desc from id_name_device where device_id=new.device_id );
end;
Subject
Views
Written By
Posted
1598
July 01, 2020 09:29AM
673
July 01, 2020 09:33AM
578
July 01, 2020 02:07PM
610
July 02, 2020 05:55AM
Re: Issues with converting update command to trigger
596
July 02, 2020 11:59AM
1018
July 02, 2020 07:10PM
643
July 02, 2020 09:45PM
626
July 03, 2020 02:53AM
605
July 03, 2020 07:17AM
613
July 03, 2020 10:43AM
580
July 03, 2020 07:46PM
619
July 15, 2020 05:33AM
636
July 15, 2020 10:33AM
631
July 15, 2020 11:02AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.