Oracle - Update string to replace only the last character

replace sql-update oracle9i substr
PhelpsK picture PhelpsK · Sep 18, 2013 · Viewed 35.1k times · Source

I have the following string in an Oracle 9i database:

A,B,C,

I need to replace all instances of ',' when it is the last item in the string. I have come up with the following statement but it deletes everything in the field not just the comma. Any suggestions?

UPDATE table SET column = REPLACE(SUBSTR(column, -1, 1), ',', '');

Answer

Vadzim picture Vadzim · Jan 14, 2015

rtrim(column, ',') is both efficient and much shorter

Related questions

How to update an SQLite database with a search and replace query?

My SQL knowledge is very limited, specially about SQLite, although I believe this is will be some sort of generic query... Or maybe not because of the search and replace... I have this music database in SQLite that has various …

Read More
How to replace all occurrences of a string?

I have this string: "Test abc test test abc test test test abc test test abc" Doing: str = str.replace('abc', ''); seems to only remove the first occurrence of abc in the string above. How can I replace all …

Read More
Renaming columns in pandas

I have a DataFrame using pandas and column labels that I need to edit to replace the original column labels. I'd like to change the column names in a DataFrame A where the original column names are: ['$a', '$…

Read More