DEVFYI - Developer Resource - FYI

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