Re: Help

From: <gmei_at_my-deja.com>
Date: 2000/02/16
Message-ID: <88ep6k$ju7$1@nnrp1.deja.com>#1/1

In article <38A9DDED.3710AC5F_at_phobos.mobinfo.com.au>, Shantha Ramaswamy <shantha_at_phobos.mobinfo.com.au> wrote:
> Hi,
> Any kind of help is valuable.
> I am in a situation to refine an existing database design.
> Certain columns have field length (eg., 2000) where the
> entire length is not used. Is it advisable to redefine the length
> appropriately. As varchar2 is non-padding is it really important to
> redefine?
>
> Thanks,
> Shan
>
>

If field (column) type is varchar2, you don't need to worry. Oracle takes care of the situation internally.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 16 2000 - 00:00:00 CST