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. If the character value is longer than the defined width of the column, Oracle aborts the insert and generates an error. 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. All Rights Reserved.