nvarchar2 -> varchar2
utl_raw.cast_to_varchar2(utl_raw.cast_to_raw(v_nm_login))
or
Translate(yourWords USING CHAR_CS)
varchar2-> nvarchar2
utl_raw.cast_to_nvarchar2(utl_raw.cast_to_raw(v_username))
or
Translate('你好' USING NCHAR_CS)
utl_raw.cast_to_varchar2(utl_raw.cast_to_raw(v_nm_login))
or
Translate(yourWords USING CHAR_CS)
varchar2-> nvarchar2
utl_raw.cast_to_nvarchar2(utl_raw.cast_to_raw(v_username))
or
Translate('你好' USING NCHAR_CS)