Hi,
I am not sure on how to convert this SQL SERVER Trigger to an oracle trigger, Can someone help please?
ALTER trigger [dbo].[TriggerAudit] on [dbo].[Order]
after update, insert, delete
as
begin
insert into Supermarket.dbo.Audit_table
(OrderID, OrderDateTime, OrderTotalPrice, OrderedBy, UpdatedBy, UpdatedOn )
select i.OrderID, i.OrderDate, i.TotalPrice, i.CustomerID, SUSER_SNAME(), getdate()
from [Order] O
inner join inserted i on O.OrderID=i.OrderID
end
Thanks for your help.