How to change the datatype of the View column?

CREATE OR REPLACE VIEW MYUSER.CLASS_VALUE (

    TARIFF_CLASS,
    DESCRIPTION
)
AS
select substr(MYUSER.XXX_DEFAULTS.VALUE,1,3) as TARIFF_CLASS, MYUSER.XXX_DEFAULTS.DESCRIPTION
from MYUSER.XXX_DEFAULTS

As one can see, the TARIFF_CLASS should be varchar2(3). However, XXX_DEFAULTS.VALUE is vachar2(9) and therefore it is also vachar2(9).

How to change the type to varchar2(3)? Received on Wed Nov 16 2005 - 09:45:29 CST