extract table to xml file

[russland]

hi, i'd like to extracte a table and a few of it columns/attributes to a xml file.

any clue on how to use DBMS_XMLQUERY properly to do so?
thanks

 

[bookouri]

Ive never heard of that dbms_xmlquery, but since the xml file is just a text document, you could very easily build the text file with text_io/utl_file, or even spooling the xml text with your sql statement. Ive done that for a couple of projects, but I dont deal with XML, other than to product files for other people's applications..

 

[russland]

there are solution

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/186/qid/716955