VIEW: LBACSYS.DBA_SA_COMPARTMENTS

Source

View Text - Preformatted

SELECT p.pol_name AS policy_name, c.comp# AS comp_num,
          c.code AS short_name, c.name AS long_name
   FROM LBACSYS.ols$pol p, LBACSYS.ols$compartments c
   WHERE p.pol# = c.pol#

View Text - HTML Formatted

SELECT P.POL_NAME AS POLICY_NAME
, C.COMP# AS COMP_NUM
, C.CODE AS SHORT_NAME
, C.NAME AS LONG_NAME
FROM LBACSYS.OLS$POL P
, LBACSYS.OLS$COMPARTMENTS C
WHERE P.POL# = C.POL#