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.



No comments: