EM12c and EM13c datasources report.

SELECT
        *
FROM
        (
                SELECT
                        'CONNECTIONPOOLS',
                        s4.cm_target_name,
                        s4.URL
                FROM
                        CM$MGMT_OC4J_CONNECTIONPOOLS s4
               
                UNION ALL
               
                SELECT
                        'MANAGED DATASOURCE',
                        s3.cm_target_name   ,
                        s3.URL
                FROM
                        CM$MGMT_OC4J_DATASOURCES s3
               
                UNION ALL
               
                SELECT
                        'NATIVE'         ,
                        s5.cm_target_name,
                        s5.URL
                FROM
                        CM$MGMT_OC4J_NATIVEDATASOURCES s5
        )
        sel