I have a challenge to overcome in SQLLDR.
I have a column TIME_AT_ADDRESS with an input format of YYMM, where YY is the number of years, and MM is the number of months at address.
I need to convert it to number of months, so 0311 (3 years, 11 months) becomes 47 (months)
However, the default value of 9999 needs to be preserved without conversion.
Can this be done purely in SQLLDR ??