Hi,
Here's my table
create table id_table (ID number)
Here's my csv file contain 37 digit number (sample.csv).
ID
123456789123456789123456789123456789
I loaded the sample.csv through,
sql -S -L /nolog 2>&1 << EOF
WHENEVER SQLERROR EXIT SQL.SQLCODE
connect $DB_CREDENTIAL
set loadformat delimited delimiter ,
show loadformat
load id_table sample.csv
EOF
No Error in load log. But, when I see the value in the table, the ID column displayed as
123456789123456780000000000000000000
What i'm missing here.