TO_SINGLE_BYTE

TO_SINGLE_BYTE(x) converts the multi-byte characters in x to the corresponding single-byte characters.

SQL> select to_single_byte('this is a test') from dual;

TO_SINGLE_BYTE
--------------
this is a test

SQL>