view with to_number
Hi,
I am trying to write a view as below:
create or replace force view text_vw (itm,
sile,
eqty,
)
as
select itm,sile,to_number(qty)
from text
where code in (2,3)
order by itm,sile,qty;
In the above view, the qty value in table 'text' is varchar2 and in the text_vw, eqty value should be converted from varchar to numeric.
Please help, with your suggestions. Thank you