Delimit with special characters

[mooks]

Hi

If I have a record which is in a string of text (Eg: Today is a special day). If I need to add a special character like '!' for every encounter of the character 's' (Eg: Today i!s a !special day), is there any sql commands to do so??

Thanks!

[DaPi]

select replace('Today is a special day', 's', '!s') from dual

[mooks]

Thanks!