oracle trigger compuesto
CREATE OR REPLACE TRIGGER compound_trigger_name
FOR INSERT | DELETE UPDATE OF column ON table COMPOUND TRIGGER
-- Sección declaratica (optional)
-- Variables se declaran durante el Trigger
--Ejecución antes de una consulta DML
BEFORE STATEMENT IS
BEGIN
NULL;
END BEFORE STATEMENT;
-- Ejecución antes de cada fila, variables :NEW, :OLD son permitidas
BEFORE EACH ROW IS
BEGIN
NULL;
END BEFORE EACH ROW;
-- Ejecución despues de cada fila, variables :NEW, :OLD son permitidas
AFTER EACH ROW IS
BEGIN
NULL;
END AFTER EACH ROW;
--Ejecución despues de una consulta DML
AFTER STATEMENT IS
BEGIN
NULL;
END AFTER STATEMENT;
END compound_trigger_name;
Are there any code examples left?
New code examples in category Other
-
Other 2023-03-27 22:50:10 how to select the whole line in vscode with keyboard shortcut
-
Other 2022-03-27 22:45:24 income of a web developer
-
Other 2022-03-27 22:35:01 \pyrcc_main.py: File does not exist 'resources.qrc'
-
Other 2022-03-27 22:30:45 rick roll embed code
-
Other 2022-03-27 22:20:08 Circuit_04_Potentiometer
-
Other 2022-03-27 22:20:05 iterative power
-
Other 2022-03-27 22:15:11 flutter run all
-
Other 2022-03-27 22:10:05 when is karlson release
-
Other 2022-03-27 22:10:02 wp .htaccess example
-
Other 2022-03-27 22:00:08 bash pause in file read line by line