Monday, November 10, 2008

Alter datatype in Oracle

alter table table_name modify ( column_name char(1))

or

ALTER TABLE table_name alter column column_name DROP DEFAULT

No comments: