NVARCHAR to VARCHAR2 insert

Question

I have the following table structure:

UDA_ID (NUMBER)
Translation (NVARCHAR2)

I need to insert in the table

UDA_ID (NUMBER)
Translation (VARCHAR2)

How do i convert NVARCHAR2 to VARCHAR2 ?

Answer 1

You can try like this:

insert into mytable(Translation)
(select to_char(Translation) from sometable);

or like

insert into mytable(Translation)
(select to_char('yourValue') from dual);