VIEW: MDSYS.ALL_SDO_NETWORK_JAVA_OBJECTS

Source

View Text - Preformatted

SELECT  sdo_owner owner, constraint name, description, class_name, class,java_interface     FROM  sdo_network_constraints     WHERE EXISTS       (SELECT  NULL         FROM  all_java_classes          WHERE owner = sdo_owner            AND name = class_name )

View Text - HTML Formatted

SELECT SDO_OWNER OWNER
, CONSTRAINT NAME
, DESCRIPTION
, CLASS_NAME
, CLASS
, JAVA_INTERFACE
FROM SDO_NETWORK_CONSTRAINTS
WHERE EXISTS (SELECT NULL
FROM ALL_JAVA_CLASSES
WHERE OWNER = SDO_OWNER
AND NAME = CLASS_NAME )