I ran into an interesting situation with Oracle's to_number function. First let me setup what I was trying to do. Bentley Comms has a table named mapindex that contains a column named mapname. This column typically contains names of maps used by the user…