Oracle Column Value Modification

I am trying to fix an issue where some of the items in my table Documents Have a typo in one of the col开发者_高级运维umns

Where it should read Important: Please Read it instead reads ImportantPlease Read

I'm using not to good with Oracle, but how would I essentially do this

Update Documents Set Overview = "Imporantant: Please Read " + 
Overview.SubStr(19, Overview.Length) Where Overview Like 'ImportantPlease Read%'

Now I know this is nowhere near Oracle Syntax but I was wondering if you could help me fill in the gaps

Thanks in advance, and please let me know if you need further explanation.

---

You probably want

UPDATE documents
   SET overview = 'Important: Please Read ' || substr( overview, 19 )
 WHERE overview LIKE 'ImportantPlease Read%'

---

Try this:

UPDATE Documents
SET Overview = REPLACE(Overview, 'ImportantPlease', 'Important: Please')
WHERE Overview LIKE 'ImportantPlease%';