VIEW: SYS.USER_AW_PROP

Source

View Text - Preformatted

SELECT 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,
     (select max(rowid) keep (dense_rank last order by gen#) rid
           from aw_prop$ group by awseq#, oid, propname)
WHERE   a.owner#=USERENV('SCHEMAID') and a.awseq#=p.awseq#
        and p.rowid = rid and p.propval IS NOT NULL

View Text - HTML Formatted

SELECT 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
, (SELECT MAX(ROWID) KEEP (DENSE_RANK LAST ORDER BY GEN#) RID
FROM AW_PROP$ GROUP BY AWSEQ#
, OID
, PROPNAME) WHERE A.OWNER#=USERENV('SCHEMAID')
AND A.AWSEQ#=P.AWSEQ#
AND P.ROWID = RID
AND P.PROPVAL IS NOT NULL