Export table/view in xml-format

Hi,

is there a tool to export contents of a table or view in xml? I would like
something that:
--- cut ---
<xml-header>
    bla and blub
</xml-header>
<tablename>
    <row>
        <column_a>data</column_a>
        <column_b>data</column_b>.
        ...
    </row>
    <row>
        <column_a>data</column_a>
        <column_b>data</column_b>
        ...
    </row>
</tablename>
<xml-footer>
    some text
</xml-footer>
--- cut ---

ciao Detlef
--
# Dipl. Ing. (FH) Detlef Jockheck
# E-mail: detlef@jockheck.de
# -------------------------------