DBA Data[Home] [Help]

VIEW: SYS.KU$_RADM_MC_VIEW

Source

View Text - Preformatted

select '1','0',
         m.obj#,
         m.intcol#,
         c.name,
         r.pname,
         m.mfunc,
         m.mparams
  from sys.radm_mc$ m, sys.radm$ r, col$ c
  where r.obj# = m.obj#
    and c.obj# = r.obj#
    and c.intcol# = m.intcol#
View Text - HTML Formatted

SELECT '1'
, '0'
, M.OBJ#
, M.INTCOL#
, C.NAME
, R.PNAME
, M.MFUNC
, M.MPARAMS
FROM SYS.RADM_MC$ M
, SYS.RADM$ R
, COL$ C
WHERE R.OBJ# = M.OBJ#
AND C.OBJ# = R.OBJ#
AND C.INTCOL# = M.INTCOL#