After installing Oracle 10g on an Ubuntu 9.04 system, i found that the Apex application was enabled only for the localhost. Some time is necessary open or close the access of apex from remote. To do this is only need to access to your oracle system by a dba user and run this sql command:…
Leggi tutto
In Oracle ,to get some ddl information and source you can call system tables like user_objects. So with a particular function called DBMS_METADATA.GET_DDL you can have the entire source of an object passing two parameter : first: the object type and the second parameter is the name of the object that you want to know…
Leggi tutto
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
