Oracle PL/SQL In PL/SQL, Trigger an event to bring item from custTwoitem table to delta file. Scenario In custTwoitem ta
Posted: Tue Jul 12, 2022 8:19 am
Oracle PL/SQL
In PL/SQL, Trigger an event to bring item from custTwoitem tableto delta file.
Scenario
In custTwoitem table when there is an update toitemTwo code (either code is updated or added new) - triggeran event to bring that specific item to delta file.
ONLY trigger this when the itemTwo code is with format -“MallCode+X”.
first you must check if the update to itemTwo codeformat is MallCode+X then add that item/SKU to delta filealong with itemTwo code added to file as well.
In PL/SQL, Trigger an event to bring item from custTwoitem tableto delta file.
Scenario
In custTwoitem table when there is an update toitemTwo code (either code is updated or added new) - triggeran event to bring that specific item to delta file.
ONLY trigger this when the itemTwo code is with format -“MallCode+X”.
first you must check if the update to itemTwo codeformat is MallCode+X then add that item/SKU to delta filealong with itemTwo code added to file as well.