Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> create view (Newbie question)
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 Mon Jan 11 1999 - 14:41:06 CST