Forum Stats

  • 3,770,031 Users
  • 2,253,051 Discussions
  • 7,875,275 Comments

Discussions

How to Load a 37 digit number from file into table using sqlcl load

User_SEI52
User_SEI52 Member Posts: 2 Green Ribbon
edited Sep 21, 2021 11:26AM in SQL Developer

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.

Tagged:

Best Answer

Answers