ALLInterview.com :: Home Page      
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
Categories >> Software >> Databases >> SQL PLSQL
 
 


 

 
Question 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?
 Question Asked At :: oracle, not in company but generally for knowledge
 Question Submitted By :: niru2377
I also faced this Question!!    
Answer Posted By  
 
Answer
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

Is This Answer Correct ?    21 Yes 0 No


 
  hannan
 
View All Answers