ORA-01858: a non-numeric character found where a digit was expected

This error comes when we try to enter a non-numeric character where a numeric character is expected.

we can use date formats recognized by the to_date function in case of date and nvl in case of null value.