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 the difference between verification and validation
what is the proper location of sample point for sphere tank?
how many protocols are available and what are they?
compare the conditional operator with if-else-if statement.
how to find out the name of the users who are currently working starting with the same characters in unix os
How to score well in examination of MCA(engg) december 2012? please reply soon........
write a c program which accept input as:Anu.B.Kapur and give out as:Kapur.A.B using pointers
I am going to HAL Online test for Computer Science. Can you please mail me the model question papers ?
what is advantages and disadvantages of vlan?
what is the need of constractor explain with sutable progarmming example
What is the strongest naturally occurring material and how can it be cut?
What will be the sql query to list the employee names those are getting 3rd highest salary ?
How to write test cases for Auditing in Health care Applications?
Tell me about a time when you had too many things to do and you were required to prioritize your tasks
Has anyone attended interviews in IITs for positions like Research fellowships/assistants? If yes, please share the experience about how complex the interview was, etc. etc.