DBA Data[Home] [Help]

VIEW: SYS.KU$_SCHEMAOBJNUM_VIEW

Source

View Text - Preformatted

select *
  from ku$_schemaobj_view ku$
  where ku$.obj_num in (select * from table(dbms_metadata.fetch_objnums))
View Text - HTML Formatted

SELECT *
FROM KU$_SCHEMAOBJ_VIEW KU$
WHERE KU$.OBJ_NUM IN (SELECT *
FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS))