DBA Data[Home] [Help]

VIEW: OLAPSYS.ALL$OLAP2UCATALOGS

Source

View Text - Preformatted

select
  catalog_id,
  catalog_name,
  parent_catalog_id,
  description
from olapsys.all$olap_catalogs
union all
select catalog_id,
  catalog_name,
  parent_catalog_id,
  description
from olapsys.all$olap2_catalogs
with read only
View Text - HTML Formatted

SELECT CATALOG_ID
, CATALOG_NAME
, PARENT_CATALOG_ID
, DESCRIPTION FROM OLAPSYS.ALL$OLAP_CATALOGS UNION ALL SELECT CATALOG_ID
, CATALOG_NAME
, PARENT_CATALOG_ID
, DESCRIPTION FROM OLAPSYS.ALL$OLAP2_CATALOGS WITH READ ONLY