Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

Tag: triggers

Digital Innovation Partner

Oracle Tips #4 [Trigger : Mutating Tables & Autonomos Transactions]

Oracle Version : 10g As you know inside a Oracle row trigger you cannot access to the base table, for example when you make a trigger like this, on a table named “activity“. CREATE OR REPLACE TRIGGER UNAME.ACTIVITY_FK_MENU_INTEGRITY AFTER INSERT OR UPDATE ON UNAME.ACTIVITY REFERENCING NEW AS New OLD AS Old FOR EACH ROW DECLARE…
Leggi tutto

FlameRobin 0.9.0 released

FlameRobin is an open source and cross platform database administration tool for Firebird DBMS. some info : Project Site : http://www.flamerobin.org/ Dev.Tools/Lang : C++ download site : http://sourceforge.net/project/showfiles.php?group_id=124340&package_id=136187& (high lights) New features – 100% Firebird 2.1 compatible – Tab-based property pages for database object (like Firefox browser) – DataGrid: load and save to file options…
Leggi tutto