Answer / shishal

VARCHAR2 is Oracle and VARCHAR is ansi standard. Regardless
how they behave or how big it can be it's simply a vendor vs
standard issue.
There is a quotation from Christopher Allen “Oracle Database
10g, PL/SQL 101”:

“There is a datatype named VARCHAR as well. In early
versions of Oracle the maximum length of a VARCAR column was
1,000 characters, later expanded to 4,000 characters for the
datatype VARCHAR2. In current version of Oracle, both
datatypes enjoy 4,000-character limit. However Oracle
Corporation says they may change the behavior of a VARCHAR
column in future – and we have no way of knowing how the
“changed” VARCHAR will behave – so…”


Varchar2 is variable width character data type, so if you
define column with width 20 and insert only one character to
tis column only, one character will be stored in database.
Char is not variable width so when you define column with
width 20 and insert one character to this column it will be
right padded with 19 spaces to desired length, so you will
store 20 characters in the dattabase .Varchar data type from
Oracle 9i is automaticlly promoted to varchar2 .

Answer / m arunachalam

These is a simple difference only...

Varchar- It can fixed size to the memory.
Ex:varchar(50)->Memory can take 50 characters to
allocate...
If You given string 'arunachalam' it contains 11 characters
and assign to memory. Remaining 39 character also assign to
empty character in memory....

Varchar2-It can fixed size by your given data length..
Ex:Varchar2(50)->Memory can take 50 characters to allocate...
If You given string 'arunachalam' it contains 11 characters
and assign to memory. Remaining 39 character here not assign
to memory and memory size should be reduced from remaining
size....

Answer / vetrivel

VARCHAR:
Stores strings of variable length.
The length parameter specifies the maximum length of the strings
It stores up to 2000 bytes of characters
It will occupy space for NULL values
The total length for strings is defined when database was created.
VARCHAR2:
Stores strings of variable length.
The length parameter specifies the maximum length of the strings
It stores up to 4000 bytes of characters
It will not occupy space for NULL values
The total length of strings is defined when strings are given.

Answer / atul

i am not satisfied to all answers because if we say that
vsize() both are give same answer pls clear my doubt .

thanks to above suggestion/ans.

Answer / deepak gupta

Thanks Shishal

What is the most important thing to know about marine engineering?

0 Answers  

how to implement spiral model on railway reservation?.

1 Answers  

searching a B-tree indexed tree compared to B+ tree is slow..True or false

0 Answers   NIC,

How small can you make a computer? What are the limiting factors?

0 Answers  

how i run the assembly language code

0 Answers  

i made lan connections ,then how can i establish the network....with that connections only is the network is established ...tell me the procedure for giving the lan connection for some(10) pc's?

0 Answers  

What are the advantages and disadvantages of Automicity, Consistency,Isolation & Durability?

0 Answers  

Please send the details and fee for Intools training course..I would like to do the course in second week of jUNE 2010.

0 Answers  

a tap can fill the empty tank in 12 hours , but due to a leak in the bottom it is filled in 15 hours. If the tank is full then tap A is closed then in how many hours the leak can empty it?

3 Answers   Mind Tree,

what is the difference between C and C++? what is the difference between scanf and gets? what is mean by extern what is the use of it? what will happen if i say delete this> Difference between C structure and C++ structure? What is the difference between overloading and overridding? Explain the need for "virtual Destructor" Can we have "virtual Constructors"? What is the different types of polymorphism> What is virtual functions? How to implement virtual function in "C"? What are the different types of storage classes?

0 Answers  

what are register variables?what are the advantages of using register variables in c language?

0 Answers  

write an algorithm in O(n) time for finding the kth smaalest element form an array of n elements , where n and k are entered by user

0 Answers