Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

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

This code snippet is great for removing trailing slashes or other characters from the end of a string.


advertisement

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 the length of a string. Then, find use SUBSTR to get the entire string except for the LENGTH minus 1.



SELECT
SUBSTR(your_column, 0, LENGTH(your_column) - 1)
FROM your_table;

This will remove the last character from your string. It's great for removing trailing slashes or other characters from the end of a string.

 

Visit the DevX Tip Bank

 



   
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date