I was reading Jeff Hunter’s problem about triggers and constraints with interest. Here is a summary of the problem:

Prior to Oracle 9i it was difficult to rename a column or a constraint. In Oracle 9i and above, this can be easily accomplished using the ALTER TABLE command. Here is an example: