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