VIEW: OLAPSYS.ALL$OLAP_CATALOGS

Source

View Text - Preformatted

SELECT
  c.irid catalog_id
, c.name catalog_name
, cp.irid parent_catalog_id
, c.description description
FROM
  cwm$classification c
, cwm$classification cp
, cwm$classificationtype cty
, cwm$classificationentry ce
WHERE cty.irid = c.classificationtype_irid
AND cty.name = 'ORACLE_OLAP_CATALOG'
AND c.irid = ce.element_irid
AND ce.name = 'CATALOG'
AND ce.classification_irid = cp.irid
UNION ALL SELECT
  c.irid catalog_id
, c.name catalog_name
, null parent_catalog_id
, c.description description
FROM
  cwm$classification c
, cwm$classificationtype cty
WHERE cty.irid = c.classificationtype_irid
AND cty.name = 'ORACLE_OLAP_CATALOG'
AND NOT EXISTS
    (SELECT null
    FROM cwm$classificationentry ce
    WHERE ce.name = 'CATALOG'
    AND ce.element_irid = c.irid)
WITH READ ONLY

View Text - HTML Formatted

SELECT C.IRID CATALOG_ID
, C.NAME CATALOG_NAME
, CP.IRID PARENT_CATALOG_ID
, C.DESCRIPTION DESCRIPTION FROM CWM$CLASSIFICATION C
, CWM$CLASSIFICATION CP
, CWM$CLASSIFICATIONTYPE CTY
, CWM$CLASSIFICATIONENTRY CE WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME = 'ORACLE_OLAP_CATALOG' AND C.IRID = CE.ELEMENT_IRID AND CE.NAME = 'CATALOG' AND CE.CLASSIFICATION_IRID = CP.IRID UNION ALL SELECT C.IRID CATALOG_ID
, C.NAME CATALOG_NAME
, NULL PARENT_CATALOG_ID
, C.DESCRIPTION DESCRIPTION FROM CWM$CLASSIFICATION C
, CWM$CLASSIFICATIONTYPE CTY WHERE CTY.IRID = C.CLASSIFICATIONTYPE_IRID AND CTY.NAME = 'ORACLE_OLAP_CATALOG' AND NOT EXISTS (SELECT NULL
FROM CWM$CLASSIFICATIONENTRY CE
WHERE CE.NAME = 'CATALOG'
AND CE.ELEMENT_IRID = C.IRID) WITH READ ONLY