0

I'm trying to load data from a CSV file. The date value in the file is correct. And in the table, some values are incorrect.

enter image description here

 CREATE TABLE "TABLE" 
   (  "TIMESTAMP" VARCHAR2(4000)
   ) 
   ORGANIZATION EXTERNAL 
    ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "UPLOAD"
      ACCESS PARAMETERS
      ( records delimited by newline
         CHARACTERSET CL8MSWIN1251
         NODISCARDFILE
         NOLOGFILE
         NOBADFILE
         skip 1
         fields terminated BY ';' OPTIONALLY ENCLOSED BY '"'
                                      )
      LOCATION
       ( "UPLOAD":'table.csv'
       )
    )
   REJECT LIMIT UNLIMITED;

What could be the mistake?

qskyhigh
  • 107
  • 1
  • 7
  • 2
    Is the displayed data from the CSV file or output from the table? Whatever it is please post the other one (preferably for the matching rows). – APC Sep 23 '19 at 07:11
  • 2
    It is a bad idea to store timestamp values as `VARCHAR2` - use `DATE` or `TIMESTAMP`. Also using reserved word `TIMESTAMP` as column name is a poor choice. – Wernfried Domscheit Sep 23 '19 at 07:57
  • 1
    Looks like you have Excel-based data there; can you edit your question to include some sample data from your file `table.csv` ? – Mark Stewart Sep 24 '19 at 22:18

0 Answers0