Convert that multibyte representation back to a single byte : TO_SINGLE_BYTE « Conversion Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Conversion Functions
3. TO_SINGLE_BYTE

SQL> DECLARE
  2     g_one_byte NVARCHAR2 (1 CHAR) := 'G';
  3     g_three_bytes NVARCHAR2 (1 CHAR);
  4     g_one_again NVARCHAR2(1 CHAR);
  5     dump_output VARCHAR2(30);
  6  BEGIN
  7     g_one_again := TO_SINGLE_BYTE(g_three_bytes);
  8     DBMS_OUTPUT.PUT_LINE(g_one_again || ' is ' ||TO_CHAR(LENGTHB(g_one_again))|| ' byte again.');
  9  END;
 10  /

PL/SQL procedure successfully completed.

SQL>