[Oracle] SQL DEV
How to solve
"Data is not compatible with column definition or is not available for a not nullable column"
"Data is not compatible with column definition or is not available for a not nullable column" is a commom error when you import data(.csv, .xlxs, .xls etc.) in [Oracle]SQL Dev.
How to solve this error is extremately easy!!!!
First, Look at "Format" in Tab "Column Definition".
You need to change Format from DD MON RRRR to DD MON RRRR hh24:mi:ss.
You can copy DD MON RRRR -> DD MON RRRR hh24:mi:ss and paste to Format.
ไม่มีความคิดเห็น:
แสดงความคิดเห็น