type conversion

ORA-01440 trying to convert FLOATs to NUMBERs

I recently came across a legacy database that was using Oracle FLOAT datatype for Primary and Foreign Keys. As the database needed some attention I was asked to get data types in order and get rid of the FLOATs in favor of NUMBER data types.

Subscribe to type conversion