Hi, can somebody please explain to me when is there a need to use the to_number function?
If i create a table with a column that has a varchar2 datatype and add a load of numeric values i can do all numeric calculations with it, eg >,=, sum, trunc, round etc so when would i ever need to use the to_number function?
Many thanks