SQL question: Views
From: blair <blair_at_mda.ca>
Date: 1996/08/27
Message-ID: <3223D314.1E80_at_mda.ca>#1/1
Date: 1996/08/27
Message-ID: <3223D314.1E80_at_mda.ca>#1/1
Is there any way to construct a view in SQLplus with derived columns
where you get to determine the length of the datatype. It seems
that in the construction of our view our dervied columns are being
set as varchar2(2000). However our columns only use up 10 spaces.
We get a problem with buffer overflow, and we don't want to reduce
arraysize and we are operating on Oracle7 so MAXDATA doesn't make
any differenc.
Any Answers
Blair
Received on Tue Aug 27 1996 - 00:00:00 CEST