Wednesday, August 7, 2019

Difference between char, varchar, varchar2

Ex: column_name CHAR(10)
If value ‘TEST’ is inserted in to the above column as the size of the data is 4 but data type size restricted to column is 10.
So, the value is occupied on this column is whole size of 10.

Ex: column_name VARCHAR(10)
If value ‘TEST 10’ is inserted in to the above column as the size of the data is 7 including null spaces but data type size restricted to column is 10.
So, the value is occupied on this column is whole size of 7.

Ex: column_name VARCHAR2(10)
If value ‘TEST 10’ is inserted in to the above column as the size of the data is 7 including null spaces but data type size restricted to column is 10.
So, the value is occupied on this column is whole size of 6 which excludes null spaces.



No comments:

Post a Comment

AME (Approval Management Engine)

AME (Approval Management Engine) : AME Stands for Oracle Approval Management Engine. AME is a self service web application that enables...