REPLACE('OPS$SPORANO', 'OPS$')
SQL> SQL> SELECT REPLACE('OPS$SPORANO', 'OPS$') 2 FROM DUAL; REPLACE ------- SPORANO Page 1