How to handle data type conversion error in Oracle sQL
In earlier version we used exception handler or some other methods to get a values if incase facing conversion errors. From 12c onwards we are having very powerful feature “default null on conversion error“. From above code we will get ORA-01843: not a valid month error to avoid these kind of conversion issue we will use DEFAULT null ON CONVERSION ERROR. From above code we … Continue reading How to handle data type conversion error in Oracle sQL