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 new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
   
 
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!!     Rank 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

 
Hannan
 
View All Answers
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com