SQL> Select *
  2    From t;

        ID NAME
---------- -------------------------
         1 Peter_OK
         2 FRANK$
         3 _HANK-SOME%
         4 __T_OM

SQL> Select Name
  2       , translate(Name
  3                  ,'aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ$_-%'
  4                  ,'aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ'
  5                  ) Translated_Name
  6       , replace(replace(replace ( replace(Name,'%',''),'-',''),'_',''),'$','') Replaced_Name
  7    From t
  8  /

NAME                      TRANSLATED_NAME           REPLACED_NAME
------------------------- ------------------------- -------------------------
Peter_OK                  PeterOK                   PeterOK
FRANK$                    FRANK                     FRANK
_HANK-SOME%               HANKSOME                  HANKSOME
__T_OM                    TOM                       TOM

SQL>