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
Printable View
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
Why not use SUBSTR?
select SUBSTR(afunction(tab.number),1,10) T_Type,tab.* from atable tab;