Delimit with special characters

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?? :confused: :rolleyes:

Thanks!

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

Thanks! :D