Forum Stats

  • 3,759,238 Users
  • 2,251,515 Discussions
  • 7,870,550 Comments

Discussions

SQLLOADER not loading correct value from csv? Please help.

Issue: Rank column of target table is loaded with 'Yes' value instead of numbers and character values in excel? Why?

Please find attached excel sheet from which i am loading data using TOAD SQLLOADER Wizard

Data_control.ctl is the control file.


Now Rank column of excel is having both numbers and characters stored as text,using sqlloader i am loading it into target table crr_stg

Table script:

CREATE TABLE ERDCRM.CRR_STG

(

 ES100     VARCHAR2(100 BYTE),

 REGION     VARCHAR2(100 BYTE),

 REVIEW_PERIOD VARCHAR2(100 BYTE),

 REVIEW_TYPE  VARCHAR2(100 BYTE),

 RANK      NVARCHAR2(20)

)

Kindly help.

Tagged:

Answers