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

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