Monday, February 28, 2011

Alter column size of an Oracle Table

Use below statement to increase or decrease column size of a table.

ALTER TABLE table_name
MODIFY column_name VARCHAR2(100)

No comments:

Post a Comment