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 ?    21 Yes 0 No


 
  hannan
 
View All Answers
 
 
Please Help Members By Posting Answers For Below Questions
 
 Question Views   Select
 
how will i became good database developer? 518
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 680
Could you please provide oca (oracle 10g) dumps for my certification ? 2191
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao... 539
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. 467
What is Materialized View? In What Scenario we Use Materialized View? 3760
in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query 440
What is window clause? 65
What packages(if any) has oracle provided for use by developers? 2218
What is extent clause in table space? 59
How global cursor can be declare with dynamic trigger ? 59
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews 299
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me 446
what is indexing, searching and user interface? 694
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details? 748
E-Mail New Answers        Answer Selected Questions