SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert null into date problem

3193178May 23 2016 — edited May 23 2016

I am using SQL Developer and importing a tsv file. the column is a date column and its nullable. in the data sometimes there isn't a value. in the import tool how do i get it to allow a null in this date column? it has a red icon on that column name and another column has the yellow icon.

I tried this but it didn't like it: NVL(MM/DD/YYYY, '01-01-1900')

This post has been answered by thatJeffSmith-Oracle on May 23 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 20 2016

Added on May 23 2016

#sql-developer

2 comments

608 views