how to fix oracle ORA-01722 invalid number error
If you have a numeric column, all you have to do is use a to_char with the right parameters; this should do the work:
If you have a numeric column, all you have to do is use a to_char with the right parameters; this should do the work: