title: Checking valid date format in oracle
body: <p>In source table we are having 4 date field columns. 2 columns are having DATE as their datatype and other are varchar2. What I want to check is the incoming data for date fields are valid, if not it should be rejected if we found it is having invalid format (other than dd/mm/yyyy) and if it like 32/02/1999 or 34/15/1999 etc.</p>
  
  <p>Can you please give me a sql query to check it.</p>
  
  <p>Thanks</p>