I was reading Jeff Hunter’s problem about triggers and constraints with interest. Here is a summary of the problem: (more…)
Filed in Oracle with Comments Off | Tags: constraint, triggerPrior 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:
(more…)