samedi 27 juin 2015

How Converting SQL Server to Oracle

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