VIEW: SYS.EXU8COL

Source

View Text - Preformatted

SELECT  tobjid, towner, townerid, v$.tname, v$.name, v$.length,
                v$.precision, v$.scale, type, isnull, conname, colid, intcolid,
                segcolid, comment$, default$, dfltlen, enabled, defer,
                v$.flags, colprop, '', '', v$.charsetid, v$.charsetform,
                v$.fsprecision, v$.lfprecision, v$.charlen,  NVL(ct$.flags, 0)
        FROM    sys.exu8col_temp v$, sys.col$ c$, sys.coltype$ ct$
        WHERE   c$.obj# = v$.tobjid AND
                c$.intcol# = v$.intcolid AND
                v$.tobjid = ct$.obj# (+) AND
                (BITAND(v$.colprop, 32) != 32 OR      /* not a hidden column */
                 BITAND(v$.colprop, 1048608)= 1048608 OR/*snapshot hidden col*/
                 BITAND(v$.colprop, 4194304) = 4194304) /* RLS hidden column */

View Text - HTML Formatted

SELECT TOBJID
, TOWNER
, TOWNERID
, V$.TNAME
, V$.NAME
, V$.LENGTH
, V$.PRECISION
, V$.SCALE
, TYPE
, ISNULL
, CONNAME
, COLID
, INTCOLID
, SEGCOLID
, COMMENT$
, DEFAULT$
, DFLTLEN
, ENABLED
, DEFER
, V$.FLAGS
, COLPROP
, ''
, ''
, V$.CHARSETID
, V$.CHARSETFORM
, V$.FSPRECISION
, V$.LFPRECISION
, V$.CHARLEN
, NVL(CT$.FLAGS
, 0)
FROM SYS.EXU8COL_TEMP V$
, SYS.COL$ C$
, SYS.COLTYPE$ CT$
WHERE C$.OBJ# = V$.TOBJID AND C$.INTCOL# = V$.INTCOLID AND V$.TOBJID = CT$.OBJ# (+) AND (BITAND(V$.COLPROP
, 32) != 32 OR /* NOT A HIDDEN COLUMN */ BITAND(V$.COLPROP
, 1048608)= 1048608 OR/*SNAPSHOT HIDDEN COL*/ BITAND(V$.COLPROP
, 4194304) = 4194304) /* RLS HIDDEN COLUMN */