I regularly attend technical conferences in order to learn, make new contacts and generally participate in whatever community that conference represents.

Over the years, I have found that the best way to increase my chances of making new friends and contacts is to speak at the conference - people are far …

One vital role of the leader is to define and enforce the processes that the team will follow. I've seen more projects fail as result of getting this wrong than any other single cause.

Do I have the definitive answer as to the process you should follow? No, I do …

Over the years, I've led, and been a member of, numerous technical teams on a wide variety of projects. Based on that experience, this series of articles documents my observations on the role of the leader in that sort of team.

Firstly, some thoughts on authority...

Says Who?

How did …

When I tell people that I don't use Microsoft Word, they are generally somewhat taken aback and then assume that, because I own a Mac rather than a Windows PC, that I just use Apple's Pages instead.

I don't!

In fact, I don't use any kind of conventional word processor …

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:

UPDATE …

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:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

and a section at the bottom which looks something like:

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
iEYEARECAAYFAkmr2UAACgkQmnCt8c1NQ98pcACdEpZpqJYifkH0NvE6krEjzA9T …