Re: create view (Newbie question)

Hmm seems like you have created the table incorrectly.

but anyway you can allways substring the field.

select substr(way_to_large_column,1,1) from table;

Regards
/Joachim
John Alden wrote in message <77dkt3$f1$1_at_linux2.inet.maherterminals.com>...
>When creating a view, I am using function to return a value for a column.
>My problem is as follows:
> How do I override the default column size with a specific size?
> Ex. The function returns varchar2.
> When performing a describe on the view the default column size
is
>varchar2(4000).
> ouch
> what I would like is varchar2(1)
>
>Thanks in advance....
>
>
Received on Tue Jan 12 1999 - 03:45:32 CST