title: How to insert data from text file where date column has date as "00-00-0000"
body: <p>I have a text file and it contains one column as "NPA_DATE", in which few rows contain date as "00-00-000". </p>
  
  <p>I am unable to load data where date is in "00-00-0000" format. I am getting the error as "Record 1: Rejected - Error on table MIS_PNPA, column NPA_DATE. ORA-01847: day of month must be between 1 and last day of month". However I want to load the data with NPA_DATE as "00-00-0000" along with other data. All other rows are getting uploaded in database. I use toad for oracle 9.0.1.8</p>