• Home
• us.fatehi
• schemacrawler-testdb
• 16.24.2
• source code
• 50_triggers_B.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.books.50_triggers_B.sql Maven / Gradle / Ivy

-- Triggers
-- Oracle syntax
CREATE TRIGGER TRG_Authors 
AFTER INSERT OR DELETE 
ON Authors 
FOR EACH ROW 
BEGIN
  UPDATE Publishers 
    SET Publisher = 'Jacob' 
    WHERE Publisher = 'John';
END;