:: 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  
in char it allocates the memory space as static where as in
varchar2 it allocates the memory space as dynamic


char is a space mapping function where as in varchar2 it is
not mapping the space it occupies the exact size of the

Is This Answer Correct ?    22 Yes 0 No

View All Answers
Please Help Members By Posting Answers For Below Questions
 Question Views   Select
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? 1220
when MSQL8.0 is in market 519
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details? 797
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000 127
What is your daily office routine? 564
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 629
what is indexing, searching and user interface? 773
What are wait events. Describe the wait event tables. 1919
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters. 545
what is single byte over head in oracle..? 690
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 721
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000 1875
what is the difference difference between procedure and packages 3198
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5 1269
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 768
E-Mail New Answers        Answer Selected Questions