Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> create view (Newbie question)

create view (Newbie question)

From: John Alden <alden_at_maherterminals.com>
Date: Mon, 11 Jan 1999 14:41:06 -0600
Message-ID: <77dkt3$f1$1@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 Mon Jan 11 1999 - 14:41:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US