I wrote this code in SqlServer. But, I want to write this code for pl/sql oracle . Could anyone help me how I can do this job?
sqlserver:
ALTER TRIGGER [dbo].[checkBalance]
ON [dbo].[Orders]
FOR insert
AS
BEGIN
IF (SELECT goodcount FROM goods WHERE id=(SELECT gid FROM Inserted)) < (SELECT gcount FROM Inserted)
BEGIN
RAISERROR ('Inventory is low',10,1)
rollback
END
Aucun commentaire:
Enregistrer un commentaire