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:
A very easy one for someone, The following insert is giving me the ORA-01722: invalid number why?
Your problem is those pernicious double quotes. Oracle SQL allows us to ignore the case of database object names provided we either create them with names all in upper case, or without using double quotes. If we use mixed case or lower case in the script and wrapped the identifiers in double quotes we are … Read more