G-9030: Try to define a default value on conversion errors.
Minor
Maintainability, Reliability, Testability
Restriction
Oracle Database 12c Release 2
Reason
When converting from strings to other datatypes using a conversion function that supports the default ... on conversion error
clause, it is a good idea to use this clause to avoid getting an error raised on bad input. The exception can be when you explicitly want an error to be raised to catch and process it in a later exception handler.
Example (bad)
1 2 3 4 5 6 7 8 9 10 |
|
Example (good)
1 2 3 4 5 6 7 8 9 10 |
|