If the character value is longer than the defined width of the CHAR column, Oracle aborts the insert and generates an error. If the value is shorter than the defined width of the column, Oracle does not blank-pad the value. Character values are stored intact, so no information is lost. The same rules apply when updating. As a result, information about trailing blanks is lost.
Character values are stored intact, so no information is lost.
The same rules apply when fetching. Otherwise, you might get an unsupported network datatype error. All Rights Reserved.