April 11, 2017

Use SUBSTR to Remove the Last Character from any String in Oracle SQL

Let’s say you have a set of string values (such as values in a column) and you want to remove the last character. But, the string values are all different lengths. How can you do that? Use a combination of the LENGTH and SUBSTR functions. First, use LENGTH to find