change column type on select

Is it possible to change the type of the column in a select?

ex:
select count(*) a
from table

the type for column a is system.decimal, I want it as a Number(9) is that possible?

Try using SQL PLUS command to preformat the column types. And you can change the name of the columns by using alias names in the select statement.

Hope it helps.

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