-
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
-
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)
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|