Database Reference
In-Depth Information
, XMLFOREST(A.CITY "City", A.COUNTRY "Country")
, XMLELEMENT("CD", XMLATTRIBUTES(CD.TITLE "Title"
, G.GENRE "Genre")
, XMLFOREST(CD.PRESSED_DATE "Released"
, CD.LIST_PRICE "Price")
,
XMLAGG(
XMLELEMENT("Song"
, XMLATTRIBUTES(S.TITLE "Title"
, T.TRACK_SEQ_NO "Track")
, XMLFOREST(S.RECORDING_DATE "Recorded"
, TRIM(S.PLAYING_TIME) "Length")
)
))).GETSTRINGVAL()
FROM ARTIST A
JOIN SONG S ON(S.ARTIST_ID = A.ARTIST_ID)
JOIN CDTRACK T ON(T.SONG_ID = S.SONG_ID)
JOIN MUSICCD CD ON(CD.MUSICCD_ID = T.MUSICCD_ID)
JOIN GENRE G ON(G.GENRE_ID = CD.GENRE_ID)
GROUP BY A.NAME, A.CITY, A.COUNTRY, CD.TITLE, G.GENRE
, CD.PRESSED_DATE, CD.LIST_PRICE
;
Figure 17.12
XMLAGG
Removes Lowest-
Level Duplication
Layer.
