VIEW: SYS.KU$_JAVA_SOURCE_VIEW

Source

View Text - Preformatted

select '1','0',
         o.obj_num, value(o),
         nvl((select j.longdbcs from sys.javasnm$ j where j.short = o.name),
             o.name),
         cast(multiset(select s.joxftobn, s.joxftlno,
                              NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, s.joxftsrc
                from  x$joxfs s
                       where s.joxftobn = o.obj_num order by s.joxftlno
                       ) as ku$_source_list_t
             ),
         sys.dbms_metadata.get_java_metadata (o.name,
                                                   o.owner_name, o.type_num)
  from sys.ku$_schemaobj_view o
  where o.type_num = 28 and
            (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0)
             OR EXISTS ( SELECT * FROM sys.session_roles
                WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, O.OBJ_NUM
, VALUE(O)
, NVL((SELECT J.LONGDBCS
FROM SYS.JAVASNM$ J
WHERE J.SHORT = O.NAME)
, O.NAME)
, CAST(MULTISET(SELECT S.JOXFTOBN
, S.JOXFTLNO
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, S.JOXFTSRC
FROM X$JOXFS S
WHERE S.JOXFTOBN = O.OBJ_NUM ORDER BY S.JOXFTLNO ) AS KU$_SOURCE_LIST_T )
, SYS.DBMS_METADATA.GET_JAVA_METADATA (O.NAME
, O.OWNER_NAME
, O.TYPE_NUM)
FROM SYS.KU$_SCHEMAOBJ_VIEW O
WHERE O.TYPE_NUM = 28 AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))