what is the difference between VARCHAR and VARCHAR2?

Answer Posted / 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....

Is This Answer Correct ?    15 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Given a number (N), program to check whether its binary form has periodic or not

1601


what are the main points to be included in our introduction when asked in hr...??

1466


How does an aeroplane stay airborne and how can some aeroplanes fly upside down?

589


what is trx?

1504


A bar of steel 24 mm in diameter was subjected to a tensile load of 60 kNs and measured extension on a 20-cm gauge length was 0.009 cm and the change in diameter was 0.00375 cm. Calculate the Bulk modulus?

1570






What are daemon Threads?

1895


What is the mistake in the following program segment ? f() { int a; void c; f2(&c,&a);}

3410


different types of protocols.......?

1437


why you are suitable to work here???? plzz give me the ans f this Q. i was told to write 200 words on the spot....

1443


why IT?

1481


Tell me about urself? asked me qstns on my resume what about higher studies any plans? where do u find urself after 3-4

1616


Please. Does someone know how to inicialize tapes in ATL? I need have 100 tapes to init inside the ATL, how is the process to complete this request?

1545


i want a richdatatable to be displayed only when a list has some value in the bean, and a datatable with header only if the list is empty. And i want the datatable to be printed only when ajax button is clicked??

1421


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

1752


What are special features of Silk Test ? In what way it is advanced than QTP?

1655