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.
