select t.COLUMN_002
from (select t.COLUMN_002
      from TABLE_001 t
      order by t.COLUMN_002
     ) t
where rownum = 1;

select t.COLUMN_002
from (select t.COLUMN_002
      from TABLE_001 t
      order by (case when substr(t.COLUMN_002) between '0' and '9' then 1 else 2 end),
               t.COLUMN_002
     ) t
where rownum = 1;