SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VARCHAR2 to NVARCHAR2

563931Mar 22 2007 — edited Mar 22 2007

Hi All,

I have a script which selects data from a varchar2 column and inserts this into a nvarchar2 column.

ex: insert into dest_table(dcol1,dcol2....dcolN) select scol1 as "DCOL1", scol2 as "DCOL2"......, scolN as "DCOLN" from src_table

dcol1,2...N = NVARCHAR2 columns
scol1,2,...N = VARCHAR2 columns

However, the data is being inserted as NULL.

Do I have to use any special conversion function to ensure that data is inserted properly?

(Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production)

Pls help

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2007

Added on Mar 22 2007

4 comments

1,412 views