Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I format this query to see each XML document from start to end?
Allow me to clear up my question, I desire a doc like:
<Provider version="9.01">
<HeaderInfo>
cmd_seq corps_id dea_id entity_seq facility_uic</Provider> Received on Thu May 26 2005 - 12:37:26 CDT
</HeaderInfo>
<Detail>
paygrade rate ssn start_date stop_date username sensitive
</Detail>
<HeaderInfo>
......
</HeaderInfo>
<Detail>
....
</Detail>
....... Header and Detail for each row