VIEW: MDSYS.ALL_SDO_NETWORK_CONSTRAINTS

Source

View Text - Preformatted

SELECT  sdo_owner owner, constraint, description, class_name, class     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
, DESCRIPTION
, CLASS_NAME
, CLASS
FROM SDO_NETWORK_CONSTRAINTS
WHERE EXISTS (SELECT NULL
FROM ALL_JAVA_CLASSES
WHERE OWNER = SDO_OWNER
AND NAME = CLASS_NAME )