what is the difference between VARCHAR and VARCHAR2?

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

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Moore's law and what limits the size of a computer chip?

601


Explain Belady's Anomaly.

1940


What are the duties of QA/QC Coordinator

2709


what are the differences between one dimensional ram and two dimensional ram?

2896


Please explain me gsm call scenario for a prepaid roamer calling to a prepaid roamer?

2036






iam from engineering information technology ... can i write group 1 exams??

1676


y the range of char is between -128 to 127 only????

1307


How do an incremental process model and certification work together to produce high quality software? In your own words, describe the intent of certification in the clean room software engineering context.

1551


What is the procedure for taking leave while detecting Epf and Esi?

1710


How Main()is called by opreting system?

1559


please tell me difference between router and cisco router

1661


in b+ trees, all the data is stored in leaf nodes. if all leaf nodes are crashed then how to get/recovery the data back?

1513


write a programe to print this string in reverse order and find out how many times letter c is repeated? string = { c was desined by dennis ritchie}. also find out the lenth of the string.

1449


I an doing Engineering in IT(4th year). i want to know what is the scope or .NET and Linux, and which is better for carrier

1363


Suppose you want to form a conceptual model of UML.What elements would you require for this purpose?

1594