Created
May 18, 2016 14:35
-
-
Save hackvan/a0cbbc488fe7e3472607877a2d1e25bf to your computer and use it in GitHub Desktop.
PL/SQL Oracle: Ejemplo del uso de la sentencia FOLLOWS en los triggers
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE test ( | |
testcol VARCHAR2(15)); | |
INSERT INTO test VALUES ('dummy'); | |
COMMIT; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE TRIGGER follows_a | |
AFTER UPDATE | |
ON test | |
FOR EACH ROW | |
BEGIN | |
dbms_output.put_line('A'); | |
END follows_a; | |
/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE TRIGGER follows_b | |
AFTER UPDATE | |
ON test | |
FOR EACH ROW | |
FOLLOWS follows_a | |
BEGIN | |
dbms_output.put_line('B'); | |
END follows_b; | |
/ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment