Re: Tool to export data in XML format?

select dbms_xmlquery.getxml('select * from scott.emp') from dual;

AFAIK, this works from V9.2 onwards

On Thu, Jun 19, 2008 at 2:00 PM, Janine Sisk <janine_at_furfly.net> wrote:

> I have a need to export data from a 9i database in XML format. Using the
> table and column names as the XML descriptors (or whatever they are called)
> would be fine. Ideally I'd like to be able to specify SQL to select a few
> records from one table and have the export include all related data from
> other tables by following the foreign key references, but if I have to
> supply the complete SQL that's ok too. The idea is to be able to provide a
> complete sample of the data in XML format.
> I've searched the archives of this list, and Googled, but all I can find
> are APIs that would let me write such a thing. This is a one-off task for a
> client, so I'd rather not write it nor do they want to pay a lot for it (I'm
> guessing Crystal Reports or the like could do this, for a price).
>
> Does anyone know of an existing tool I could use?
>
> thanks,
>
> janine
>
> ---
> Janine Sisk
> President/CEO of furfly, LLC
> 503-693-6407
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l