Hi Team, I am creating a table in oracle from SAS e.g. proc sql; create table STUDYPDR.tmp as select schema_s as schema_s from study_s; quit; schema_s is char datatype in sas, when it gets created in oracle the datatype becomes varchar2. I want to create a table with NVARCHAR2, Ny way in PROC SQL or using LIBNAME. Basically I have a big dataset, Is there any way to create NVARCHAR2 for all columns with char datatype while creating in oracle. Ny help will be appreciated.
... View more