This content has been marked as final. Show 2 replies
By defining the field as VARCHAR2(20 CHAR) you tell Oracle to allocate enough space to store 20 characters, no matter how many bytes it takes to store each one. (but in your case it is 4 byte depend on database character set)
you can see char length is 20 which is equal to varchar2(20) and data length is equal to Length of the column in bytes.......1 person found this helpful
you can add 20 characters in column which have size upto 80bytes...