The 'magic' for want of a better word that makes this happen is triggers. This is a feature of high-end database systems like Oracle, SQL Server and MySQL that causes program code to execute via the ...

Application contexts enable you to store data in memory for applications to use. The After Logon database trigger is a convenient way to initialize a user session by setting application context values ...

I have a report that goes and does a sort of field validation/quality assurance check.<BR><BR>Basically it runs a bunch of sub queries and shows a summary report.<BR ...