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
   Testimonials 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 In Companies :: Oracle,     < I also faced this Question! >
 Question Submitted By :: niru2377
  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 ?    22 Yes 0 No


 
  hannan
 
View All Answers
 
 
Please Help Members By Posting Answers For Below Questions
 
 Question Views   Select
 
What action do you have to perform before retrieving data from the next result set of a stored procedure ? 833
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews 305
What is window clause? 114
hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification 384
Could you please provide oca (oracle 10g) dumps for my certification ? 2231
which will default fire first  statement level trigger or row level trigger 109
How well can multiple sessions access the same data simultaneously ? 504
i have some prob lem to tell me about my self in interview first round ... 322
What packages(if any) has oracle provided for use by developers? 2279
My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care? 4
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution 703
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far? 6
if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time 716
What are wait events. Describe the wait event tables. 1853
when MSQL8.0 is in market 484
E-Mail New Answers        Answer Selected Questions