length of number column as a char in view

[danisha]

I have a table with a field of data type number of lenght 2. But when I create a view on this by converting number field to char the lenght of the column in the view becomes 40.

create table try ( col1 number(2));

create view try_view as select to_char(col1)'xy' from try;

Here the lenght of column becomes varchar2(40).

Any Idea.