Using VALIDATE_CONVERSION function in 12cR2
In 12cR2, there is a new function introduced to determine that whether a given input can be converted to a given data type or not. Using this function , it’s easy to determine that whether the column values can be converted or not. If the conversion is possible, the function returs 1 else it returns … [Read more…]