Re: Oracle to XML Conversion

From: Hari Om <hari_om_at_hotmail.com>
Date: 5 Feb 2004 12:49:05 -0800
Message-ID: <d1d5ebe4.0402051249.475fbd0e@posting.google.com>

THANKS Richard. I tried to foolow your instructions. Here is what I did:

---

SQL>spool xml.try
SQL> select dbms_xmlgen.getxml('select
id,first_nm,last_nm,created_on,updated_on from person') from dual;

DBMS_XMLGEN.GETXML('SELECTID,FIRST_NM,LAST_NM,

---

<?xml version="1.0"?>
<ROWSET>
 <ROW>
  <PERSON_UID>100637</PERSON_UID>
  <FIRST

SQL> spool off

---

As seen above it shows only ONE Record and that too it is incomplete wonder why..... do I have to run rhis in a LOOP to DISPLAY ALL RECORDS.....? Richard Kuhler <noone_at_nowhere.com> wrote in message news:<NNdUb.7557$ow4.3510_at_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>
> ...
Received on Thu Feb 05 2004 - 14:49:05 CST