Re: Maximum column name length

From: <joseph_testa_at_aep.com>
Date: Fri, 01 May 1998 11:35:33 -0600
Message-ID: <6ictkl$pup$1@nnrp1.dejanews.com>

30 bytes, its a varchar2(30), do a desc user_tab_columns(column_name attribute)unless you're on oracle 8.0.3 then you need to do a desc sys.user_tab_columns :)

joe
http://www.oracle-dba.com

In article <6ia6b6$lrn$1_at_nnrp1.dejanews.com>#1/1, 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.
>
> Thanks in advance,
> Jamie Burks
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 01 1998 - 12:35:33 CDT