VIEW: SYS.DBA_AW_PROP

Source

View Text - Preformatted

SELECT u.name, a.awseq#, a.awname, p.oid, p.objname,
       p.propname, dbms_aw.olap_type(nvl(p.proptype, 0)),
       dbms_aw.prop_val(p.rowid), dbms_aw.prop_clob(p.rowid),
       dbms_aw.prop_len(p.rowid)
FROM aw$ a, aw_prop$ p, user$ u,
     (select max(rowid) keep (dense_rank last order by gen#) rid
           from aw_prop$ group by awseq#, oid, propname)
WHERE   a.owner#=u.user# and a.awseq#=p.awseq#
        and p.rowid = rid and p.propval IS NOT NULL

View Text - HTML Formatted

SELECT U.NAME
, A.AWSEQ#
, A.AWNAME
, P.OID
, P.OBJNAME
, P.PROPNAME
, DBMS_AW.OLAP_TYPE(NVL(P.PROPTYPE
, 0))
, DBMS_AW.PROP_VAL(P.ROWID)
, DBMS_AW.PROP_CLOB(P.ROWID)
, DBMS_AW.PROP_LEN(P.ROWID) FROM AW$ A
, AW_PROP$ P
, USER$ U
, (SELECT MAX(ROWID) KEEP (DENSE_RANK LAST ORDER BY GEN#) RID
FROM AW_PROP$ GROUP BY AWSEQ#
, OID
, PROPNAME) WHERE A.OWNER#=U.USER#
AND A.AWSEQ#=P.AWSEQ#
AND P.ROWID = RID
AND P.PROPVAL IS NOT NULL