Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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> --