VIEW: LBACSYS.DBA_LBAC_LABEL_TAGS

Source

View Text - Preformatted

SELECT pol_name AS policy_name,
         slabel AS labelvalue,
         nlabel AS labeltag,
         DECODE (l.flags,2,'USER LABEL',
                 3, 'USER/DATA LABEL','UNDEFINED') AS
         labeltype
  FROM LBACSYS.ols$lab l, LBACSYS.ols$pol p
  WHERE p.pol# = l.pol#

View Text - HTML Formatted

SELECT POL_NAME AS POLICY_NAME
, SLABEL AS LABELVALUE
, NLABEL AS LABELTAG
, DECODE (L.FLAGS
, 2
, 'USER LABEL'
, 3
, 'USER/DATA LABEL'
, 'UNDEFINED') AS LABELTYPE
FROM LBACSYS.OLS$LAB L
, LBACSYS.OLS$POL P
WHERE P.POL# = L.POL#