New course! Every coder should learn Generative AI!
Try a free lesson+ 1
What is the difference between varchar2 and varchar???
2 Answers
+ 2
They globally behave the same.
VARCHAR seems to be reserved (by Oracle) for support distinction between NULL and empty string in future.
So it's better to use VARCHAR2 as VARCHAR is reserved for future usage.
- 1
it's almost same but varchar can take only 2000 characters where as varchar2 can take 4000 characters....
Often have questions like this?
Learn more efficiently, for free:
