datatype in view

hi,

i am creating a view that is built from from a table and another view. it is constructed like this:

create view view1 as
select a.column1,

          decode(a.column2,'T',a.column3,b.column3) column3 from table1 a,

       view1 b
where a.column1 = b.column1

when i describe view2 the datatype for column3 is displayed as varchar2(10).
when i describe table1 the datatype for column3 is displayed as char(10).
when i describe view1 the datatype for column3 is displayed as char(10).

i need the datatype for view2.column3 to be a char(10). is there a way to force the use of this datatype in the creation of the view.

thanks!

Ty O'Kelly
tokelly_at_openplus.com Received on Mon Oct 25 1999 - 16:52:19 CDT