Have you ever tried to order by a VARCHAR2 column that has numeric information in it? Your query is sorted ALPHABETICALLY instead of numerically. That is, your order is 1,10,2,20,200,3,4… instead of 1,2,3,4,10,20,200. If you try to use TO_NUMBER in
Have you ever tried to order by a VARCHAR2 column that has numeric information in it? Your query is sorted ALPHABETICALLY instead of numerically. That is, your order is 1,10,2,20,200,3,4… instead of 1,2,3,4,10,20,200. If you try to use TO_NUMBER in