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: Continue reading…

Comments Off | Filed in Oracle | 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: Continue reading…

2 Comments | Filed in Oracle | Tags: ,