UPDATE    
     ** 
SET     
    MESSAGE = REPLACE(MESSAGE,'good bye','bye bye') 
WHERE     
    MESSAGE LIKE '%good bye%'

SQL> declare
  2      v_val varchar2(1000) := 'good
  3                                  bye';
  4  begin
  5      dbms_output.put_line(replace(v_val,'good bye','bye bye'));
  6      dbms_output.put_line(regexp_replace(v_val,'good[[:space:]]*bye','bye bye',1,1,'m'));
  7  end;
  8  /
good
                                bye                                                                
bye bye                                                                         

已順利完成 PL/SQL 程序.

SQL> spool off;