select
catalog_id,
catalog_name,
parent_catalog_id,
description
from olapsys.dba$olap_catalogs
union all
select catalog_id,
catalog_name,
parent_catalog_id,
description
from olapsys.dba$olap2_catalogs
with read only
SELECT
CATALOG_ID
,
CATALOG_NAME
,
PARENT_CATALOG_ID
,
DESCRIPTION
FROM OLAPSYS.DBA$OLAP_CATALOGS
UNION ALL
SELECT CATALOG_ID
,
CATALOG_NAME
,
PARENT_CATALOG_ID
,
DESCRIPTION
FROM OLAPSYS.DBA$OLAP2_CATALOGS
WITH READ ONLY
|
|
|