Skip to Main Content

Oracle Database Discussions

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!

SQLLOADER not loading correct value from csv? Please help.

User_AS6XDSep 15 2021

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
CTE BR Upload consolidated.xlsx (79.46 KB)Data_control.ctl.txt (216 Bytes)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.

Comments

Post Details

Added on Sep 15 2021
1 comment
307 views