To number

  SELECT TO_NUMBER('f', 'x') FROM dual;

select CASE WHEN xy > 0 and xy < 1 then '0' || xy else xy||'' end xy end from dual;