Re: Maximum column name length

From: Ed Bruce <Ed.Bruce_at_ha.hac.com>
Date: Mon, 04 May 1998 16:42:20 -0500
Message-ID: <354E363C.EA1E1D1E@ha.hac.com>

jburks_at_sync-link.com wrote:
>
> What is the maximum length of a column name in Oracle? I have a source that
> told me it was 18, but I have some doubts about the source.

As others have told you it is 30. But I was informed by an Oracle instructor that she had been told that any object name over 18 or so (I don't recall the exact number) characters caused a slight performance hit. So maybe your source was attempting to help you get that little extra performance. By the way this applies to all object names. Not just columns.

later,
Ed Bruce
Raytheon Systems Co. Received on Mon May 04 1998 - 16:42:20 CDT