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
Hello, we want to sync two directories in two different server that are connected to the internet. We want to use ssh as channel protocol because we already have the firewall rules to connect and because it is encrypted. First of all we need that machine A will connect to machine B without password asking,…
Leggi tutto
L’inversione di tendenza ? ma speriamo di no, che l’Open Source abbia permesso a milioni di società e di individui singoli di poter accedere ,e dare il proprio contributo ,a Software prima inarrivabili è ormai noto. Era normale aspettarsi che tutti coloro che giustamente vivono sulle licenze dei “loro” software non vedano di buon occhio…
Leggi tutto
by using some simple view in Oracle you can extract a lot of information about your DB schema, some explicit samples : (assuming that MyDBOwner is the owner of the DB and ACTIVITY is a table of a schema, this sample is succesfully tested on Oracle 10g) — LIST OF USERS select OWNER,COUNT(DISTINCT TABLE_NAME) from…
Leggi tutto
(This article is a draft but if something is of interesting …. ) The fantastic world of old Midas now called DataSnap introduced the TClientDataSet component , that is a in memory DataSet for Delphi and C++ Builder. With TClientDataSet was introduced the concept of Brief Case model Application Style. A brief case model App.…
Leggi tutto
Delphi was born exactly fifteen years ago from Today, Marco Cantu on his web site have posted a great article on this because he is one of the first guru of this beatifull dev language… the article
