Issue in uploading from csv to Oracle Database
Hi All,
I did some interfaces to data upload data from external applications to Oracle Database. So I export the data in to a .csv and update it to the Oracle.
I have used both external tables and utl.file methods.
But In both methods i found a common issue, that is the last column in the csv file updates with an <enter>. (Please find the link for more details).
It returns error when interfacing, ( I used trim function also).
So Every time i update a temp column as last and i did the interfacing part.
I did some interfaces to data upload data from external applications to Oracle Database. So I export the data in to a .csv and update it to the Oracle.
I have used both external tables and utl.file methods.
But In both methods i found a common issue, that is the last column in the csv file updates with an <enter>. (Please find the link for more details).
It returns error when interfacing, ( I used trim function also).
So Every time i update a temp column as last and i did the interfacing part.
0