change column type on select

[Highlander]

SELECT TO_NUMBER(TO_CHAR(COUNT(*), '999999999'))
FROM DUAL;