The mejor defference between varchar2 and char is fixed length and variable length . varchar2 have varible length mean if we declare as 20 space and its use only 5 space the memory asigne only 5 . but in char takes daclare space while use any number space less than declare
RE: In Oracle varchar2 takes dynamic space for storage...
The mejor defference between varchar2 and char is fixed length and variable length . varchar2 have varible length mean if we declare as 20 space and its use only 5 space the memory asigne only 5 . but in char takes daclare space while use any number space less than declare
RE: In Oracle varchar2 takes dynamic space for storage...
char is fixed we know and therefore this is also sure that whenever we will use that it will fix the memory space accordingly still we use it because while working sometimes we are sure that one of the column value should not be tampered or u may say shoulod not be allowed to be tampered by giving them more space so we fix that particular column as char.
RE: In Oracle varchar2 takes dynamic space for storage...
When we export external data then we used fixed lenght of record this is possible by char or second reson is whenever we use varchar it stores its width which occupies memory. so here two reson is sufficient for char.
2 
0