Showing posts with label column to be modified must be empty to decrease precision or scale. Show all posts
Showing posts with label column to be modified must be empty to decrease precision or scale. Show all posts

Jan 17, 2013

Modify Datatype


Column having number(5) and Char(5) datatype for a particular table cant reduce its size even if that column contains data with length 1 .

But can reduce the size of varchar/varchar2 even if the table is not empty .


Column having number(5) ,varchar2(5) and Char(5) datatype for a particular table can increase size.