Skip to content

Instantly share code, notes, and snippets.

@hackvan
Created May 18, 2016 14:35
Show Gist options
  • Save hackvan/a0cbbc488fe7e3472607877a2d1e25bf to your computer and use it in GitHub Desktop.
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
CREATE TABLE test (
testcol VARCHAR2(15));
INSERT INTO test VALUES ('dummy');
COMMIT;
CREATE OR REPLACE TRIGGER follows_a
AFTER UPDATE
ON test
FOR EACH ROW
BEGIN
dbms_output.put_line('A');
END follows_a;
/
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