-2
need to ask a question, I am using this to_date shown below, for now we have no validation and sometimes the user puts the character (...) or other invalid character in the field date, breaking thus to_date, please as I can only pick up the date and when it is invalid character it should show on the line a blank die or a predefined fixed date, as if it were an if because the line with the invalid date will have to come too.
TO_DATE(PESQUISA_MEDALHA.PREVISAO_ENVIO, 'DD/MM/YY') = trunc(SYSDATE)
could not treat this error in the application not to let the user inform invalid date? I think better than do treatment in this condition (I believe you are performing a select)
– JMSlasher