DBA Data[Home] [Help]

VIEW: SYS.KU$_OPTION_VIEW_OBJNUM_VIEW

Source

View Text - Preformatted

select oo.obj_num,oo.schema_obj.owner_name,oo.schema_obj.name,
        oo.impc_flags, oo.tag
  from ku$_option_objnum_view oo
  where oo.tgt_type=4            /* type is 'view' */
View Text - HTML Formatted

SELECT OO.OBJ_NUM
, OO.SCHEMA_OBJ.OWNER_NAME
, OO.SCHEMA_OBJ.NAME
, OO.IMPC_FLAGS
, OO.TAG
FROM KU$_OPTION_OBJNUM_VIEW OO
WHERE OO.TGT_TYPE=4 /* TYPE IS 'VIEW' */