varchar to nvarchar data conversion

[ms_reddy]

Hi,

We have a new table designed to store NVARCHAR type of data. That needs to be populated with some existing data from another table of VARCHAR2 type. Is there any function for data type conversion?

Thanks in advance...

M S Reddy

[Shestakov]

Oracle will do automatic data type conversion between VARCHAR2 and NVARCHAR2
See:
http://download-east.oracle.com/otnd...nts2.htm#45443
(table: Table 2-9 Explicit Type Conversion)

[ms_reddy]

I got it. See an example below

> create table abc (a varchar2(20));

Table created.

> insert into abc values ('Varchar2');

1 row created.

> /

1 row created.

> create table bcd (a nvarchar2(20));

Table created.

> insert into bcd select translate(a using NCHAR_CS) from abc;

2 rows created.


Thanks
MS Reddy