For complete tips on Oracle alter table syntax, see the book "Easy Oracle Jumpstart". Oracle provides "alter table" syntax to modify data columns in-place in this ...
www.dba-oracle.com