Varray auslesen
En Varray usläse am Bispiel voneme Audit ufere Adrässe
with addr as(
select ad.id aud_id
,ca.name addr_type
,ad.doc_id
,su.name sec_user
,ad.timestamp
,oa.bu_id
from obj_addr oa
,aud ad
,code_addr_type ca
,sec_user su
where 1 = 1
and ad.obj_id = oa.obj_id
and oa.addr_type_id = ca.id
and ad.sec_user_id = su.id
and ad.meta_typ_id = 101
and oa.bu_id in (1,2,9)
and ad.timestamp => '01-JAN-2011'
and ad.timestamp < '01-JAN-2012'
)
select get_obj(ad.bu_id)"BU"
,ad.addr_type "Address Typ"
,ad.doc_id "Order"
,ad.sec_user "User"
,trunc(ad.timestamp) "Datum"
,al.old_item_val "Alter Wert"
,al.new_item_val "Neuer Wert"
from addr ad
,aud_item ai
,table (ai.log) al
where ad.aud_id = ai.aud_id
and al.item_id = 3892
and al.item_seq_nr = 40
order by ad.bu_id, ad.timestamp
