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
What is Moore's law and what limits the size of a computer chip?
Explain Belady's Anomaly.
What are the duties of QA/QC Coordinator
what are the differences between one dimensional ram and two dimensional ram?
Please explain me gsm call scenario for a prepaid roamer calling to a prepaid roamer?
iam from engineering information technology ... can i write group 1 exams??
y the range of char is between -128 to 127 only????
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.
What is the procedure for taking leave while detecting Epf and Esi?
How Main()is called by opreting system?
please tell me difference between router and cisco router
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?
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.
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
Suppose you want to form a conceptual model of UML.What elements would you require for this purpose?