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.
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