1 Reply Latest reply on Feb 17, 2016 10:11 PM by 3049623

    IMPORT METHOD - NULL DATE FAILS

    3049623

      i am importing a csv file and unfortunately sometimes there is no data in the date of birth field.

      i have my table set up as DATA and to allow nulls.

      When I go thru the sql developer import method and get to the columns area, for format i am putting MM/DD/YYYY and this works fine if there is data in that column but if there isn't then it fails.

      how can i resolve this to put NULL or 00/00/0000 or what is another solution?

      thank you.

       

        • 1. Re: IMPORT METHOD - NULL DATE FAILS
          3049623

          My mistake.  Apparently i had one column missing and it was throwing off the insert.  i found this out by changing the INSERT to an INSERT SCRIPT and then looked at the details of the script. once i added the missing column (state), it put a NULL where there was a blank, so all is good. my apologies.