SQL>SQL>SQL> select replace( 'Oracle is great!', 'great', 'awesome' ) 2 from dual 3 /REPLACE('ORACLEISG------------------Oracle is awesome!1 row selected.SQL>SQL> --