VIEW: SYS.KU$_CONSTRAINT0_VIEW

Source

View Text - Preformatted

select c.owner#, c.name, c.con#, cd.obj#, cd.cols, cd.type#,
          NVL(cd.enabled,0),
          cd.intcols, to_char(cd.mtime,'YYYY/MM/DD HH24:MI:SS'), cd.defer
   from con$ c, cdef$ cd
   where c.con# = cd.con#
     and cd.type# in (5,7,11)  -- view WITH CHECK OPTION (5)
                               -- NOT NULL on built-in datatyped column (7)
                               -- NOT NULL on ADT column (11)

View Text - HTML Formatted

SELECT C.OWNER#
, C.NAME
, C.CON#
, CD.OBJ#
, CD.COLS
, CD.TYPE#
, NVL(CD.ENABLED
, 0)
, CD.INTCOLS
, TO_CHAR(CD.MTIME
, 'YYYY/MM/DD HH24:MI:SS')
, CD.DEFER
FROM CON$ C
, CDEF$ CD
WHERE C.CON# = CD.CON#
AND CD.TYPE# IN (5
, 7
, 11) -- VIEW WITH CHECK OPTION (5) -- NOT NULL ON BUILT-IN DATATYPED COLUMN (7) -- NOT NULL ON ADT COLUMN (11)