What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?
ORACLE Interview Questions and Answers (Part 4)
(Continued from previous question...)
584. What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?
CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.
(Continued on next question...)
Other Interview Questions
|