1.5.1: Excel import - Problem with NULL values in date fileds
10368Sep 18 2008 — edited Sep 18 2008Hi,
I'm trying to import Excel Data via CSV with the import into table feature of SQLDeveloper.
Everything works fine, but if I select some of my date colums I get an error telling me that I have null or invalid values in a date column:
Verifying if the Date columns have date formats
FAILED
Date columns SOA_CONTROLLING_NO, SOA_DATE_OF_CONTROLLING, PAYOUT_ME_2_SUM, PAYOUT_ME_1_SUM, PAYOUT_PLUS_SUM, PAYOUT_6_SUM, PAYOUT_5_SUM, PAYOUT_4_SUM, PAYOUT_3_SUM, PAYOUT_2_SUM, PAYOUT_1_SUM, CONTRACT_APPENDIX_SUM, CONTRACT_BASE_SUM, ME_CONVENANT_SUM, REF_SUM_NO_REPAY, SEL_CONVENANT_SUM, ME_REQ_SUM, REF_REQ_SUM_NO_REPAY, SEL_REQ_SUM, have invalid or null date formats
I tried:
+20012121313,demo1,,+
+20012121313,demo1,NULL,+
+20012121313,demo1,to_date(NULL),+
but none of them worked...
How may I import those columns, where some of the rows contain NULL values?
Same story using 1.5... ;-(
Thank you!
Best regards,
Johann