Cannot insert null into column- import data to Oracle table.
Data is loaded to table test_today from dat file.
then when I execute the below statement, get error
INSERT INTO testload (country,tatno, name, type, desc)
SELECT col1
,col2
,col3
,col4
,col5
,col6
,col7
FROM test_today
WHERE depid=3434343
Getting error cannot insert null into column country.
But all the rows in table test_today has values. I have checked completely
I tried to replace with chr (13) and char (10) but still am getting the same error.
Any suggestions appreciated.