VIEW: SYS.EXU7COL

Source

View Text - Preformatted

select tobjid, towner, townerid, v$.tname, v$.name, v$.length, v$.precision,
                    v$.scale, type, isnull, conname, colid, segcolid,
		    comment$, default$,
                    dfltlen, enabled
   FROM EXU7col_temp v$, sys.col$ c$
    where c$.obj# = v$.tobjid and c$.col# = v$.colid and
          bitand(c$.property, 32) != 32	/* Not a hidden column */

View Text - HTML Formatted

SELECT TOBJID
, TOWNER
, TOWNERID
, V$.TNAME
, V$.NAME
, V$.LENGTH
, V$.PRECISION
, V$.SCALE
, TYPE
, ISNULL
, CONNAME
, COLID
, SEGCOLID
, COMMENT$
, DEFAULT$
, DFLTLEN
, ENABLED
FROM EXU7COL_TEMP V$
, SYS.COL$ C$
WHERE C$.OBJ# = V$.TOBJID
AND C$.COL# = V$.COLID AND BITAND(C$.PROPERTY
, 32) != 32 /* NOT A HIDDEN COLUMN */