What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
in char it allocates the memory space as static where as in varchar2 it allocates the memory space as dynamic OR char is a space mapping function where as in varchar2 it is not mapping the space it occupies the exact size of the string