Re: this doesn't look right

This still begs the question why varchar(4000) in the underlying table if column names are only allowed to be 30? Is this table used for other objects that can have a longer name? If so what?

Rodd

On Mon, 2002-12-30 at 16:08, Shaleen wrote:
> Varchar2(4000) is coming from sys.attrcol$ table. dba_tab_columns does not
> have a join this table. I am sure there are people on this list who'll
> enlighten me about contents of sys.attrcol$ table.
>
> select u.name, c.name, o.name,
> decode(ac.name, null, col.name, ac.name), cc.pos#
> from sys.user$ u, sys.con$ c, sys.col$ col, sys.ccol$ cc, sys.cdef$
> cd,sys.obj$ o, sys.attrcol$ ac
> where c.owner# = u.user#
> and c.con# = cd.con#
> and cd.type# != 12 /* don't include log groups */
> and cd.con# = cc.con#
> and cc.obj# = col.obj#
> and cc.intcol# = col.intcol#
> and cc.obj# = o.obj#
> and col.obj# = ac.obj#(+)
> and col.intcol# = ac.intcol#(+)
>
> -Shaleen
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, December 30, 2002 12:23 PM
>
>
> > As part of the process of making sure that null/not null constraints
> > are consistent across development/staging/production, I'm looking at
> > the dba_cons_columns table.
> >
> > Now, as far as I know, column_names are limited to 30 characters,
> > correct? If so, why is the column_name column in dba_cons_columns
> > (9.2.0.1) a varchar2(4000)? I realize that the "extra space" isn't used
> > and is never allocated so it's not like this is wasteful.
> >
> > But it's inconsistent with everything else, since dba_tab_columns has a
> > column_name column of varchar2(30).
> >
> > anyone know why this is like this?
> >
> > Rachel
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
Rodd Holman
roddholman_at_hotpop.com

Romans 1:16-17

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rodd Holman
  INET: roddholman_at_hotpop.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).