Eddie Awad has an interesting post on generating xml using cursor expressions: Producing XML from SQL using cursor expressions. Be sure to also read Aino’s comment, where he shows how you can achieve the same thing but using the xmlelement and xmlagg functions.