Updating into string functions
Once you assign a string to a variable, you most likely need to analyze the contents of that string, change its value in some way, or combine it with other strings.
If you leave off the length constraint, Oracle Database automatically uses a maximum length of 1.Consider the following block, which mixes variable and fixed-length strings: At first glance, you would expect that the word “Equal” would be displayed after execution. Instead, “Not Equal” is displayed, because the value of l_fixed has been padded to a length of 10 with spaces.Consider the padding demonstrated in the following block; you would expect the block to display “Not Equal”: You should, as a result, be very careful about the use of the CHAR datatype, whether as the type of a variable, database column, or parameter.Instead, the
Search for updating into string functions:
In other words, the symbols in a string might consist of English letters, such as ”A” or ”B.” They might also consist of Chinese characters, such as 字串.