Replaces the first occurrence of a character in a string with a specific character

The Replace function can directly change a particular value in a string or field to a value that needs to be replaced

If you replace only the first or second occurrence of a character, we can use InStr to get the implementation:

Select Replace (substr (Col,1,instr (col, ' a ', 1) +length (' a ')-1), ' A ', ' 0 ')

|| substr (Col,instr (col, ' a ', 1) +length (' a '))

From (

Select ' C,a,b,c,a,d ' as Col from dual);

PostgreSQL

Select Replace (substring (col,1,position (' ab ' in col) +length (' AB ')-1), ' ab ', ' # # # ') | | SUBSTRING (col,position (' ab ' in col) +length (' AB '))

From (

Select ' C,ab,b,c,a,d ':: text as col) T;

This article is from the "8016776" blog, please be sure to keep this source http://8026776.blog.51cto.com/8016776/1688085

Replaces the first occurrence of a character in a string with a specific character