Re: Oracle to XML Conversion

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 04 Feb 2004 21:49:33 GMT
Message-ID: <NNdUb.7557$ow4.3510@twister.socal.rr.com>

Hari Om wrote:

> Can any one give me some sample examples of Oracle to XML Conversion?
> Thanks!
>

<snip>

I'm not sure what you are asking for exactly. Here's a demonstration of using DBMS_XMLGEN like I suggested ...

select dbms_xmlgen.getxml('select * from all_tables') from dual

<?xml version="1.0"?>
<ROWSET>
<ROW>

   <OWNER>SYS</OWNER>
   <TABLE_NAME>AUDIT_ACTIONS</TABLE_NAME>
   <TABLESPACE_NAME>SYSTEM</TABLESPACE_NAME>

...

--
Richard

Received on Wed Feb 04 2004 - 15:49:33 CST