When I use a function in a view it results in a varchar2(4000)
type. I would like to type cast it to varchar2(10)

create or replace view aview as
select afunction(tab.number) T_Type,tab.*
from atable tab;

How can do that?

Lars