Date Series Part 8 of Agresso Management Tags ERP / Agresso

In the following scenarios, we assume the existence of a production environment and one staging environment (stg1) on separate hardware.

The purpose of these scenarios is simply to demonstrate how the principles described above might be applied to real situations.

Scenario 1

A new requirement has been defined for additional …

more ...

Oracle Update Statements

There are several methods in Oracle SQL to update records in one table based on the content of another table.

Here, I give some of those methods and some guidance on where they might be most appropriate.

The Basics

Oracle uses a 'correlated subquery' syntax which looks like this:

more ...

PGP Signatures on Email

Date Tags pgp / email

You're probably here because you've received an email from me with an attachment called 'signature.asc' or with lines at the top similar to:

Hash: SHA512

and a section at the bottom which looks something like:

Version: GnuPG v1.4.9 (MingW32)
iEYEARECAAYFAkmr2UAACgkQmnCt8c1NQ98pcACdEpZpqJYifkH0NvE6krEjzA9T …
more ...