Re: Issues with converting update command to trigger
> IF (NEW'.unit_of_measure'='%') THEN
1 Column does not exist in my version of this table
2 Backtick not quote: NEW.unit_of_measure or NEW.`unit_of_measure`
3 Period before the backtick
> ELSEIF (NEW.'unit_of_measure'='F')
Missing THEN
Subject
Views
Written By
Posted
2199
July 01, 2020 09:29AM
1056
July 01, 2020 09:33AM
915
July 01, 2020 02:07PM
994
July 02, 2020 05:55AM
945
July 02, 2020 11:59AM
1394
July 02, 2020 07:10PM
1044
July 02, 2020 09:45PM
1005
July 03, 2020 02:53AM
952
July 03, 2020 07:17AM
1083
July 03, 2020 10:43AM
915
July 03, 2020 07:46PM
1108
July 15, 2020 05:33AM
Re: Issues with converting update command to trigger
1009
July 15, 2020 10:33AM
1021
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.