msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

Triggers and Constraints

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: ,


Rename column or constraint in Oracle

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: (more…)

Filed in Oracle with 2 Comments | Tags: ,