Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How do I format this query to see each XML document from start to end?

How do I format this query to see each XML document from start to end?

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 26 May 2005 09:02:54 -0700
Message-ID: <1117123374.422927.88430@g44g2000cwa.googlegroups.com>


I have the following query that returns 23 rows as individual XML docs but I can only see part of each document. I would really like all 23 rows to be within this tag
<Provider version=9.01> ..... </Provider>

I think I need to use xmlagg before HeaderInfo element select xmlelement( "provider",

          xmlattributes( '09.01.00' as "version"),
		    xmlelement("HeaderInfo",
			  xmlforest(cmd_seq      as "cmd_seq",
			            corps_id     as "corps_id",
				      dea_id       as "dea_id",
				      entity_seq   as "entity_seq",
				facility_uic as "facility_uic")),
	xmlelement("Detail",
		xmlforest(fname||' '||lname||''||suffix as "Name",
			  paygrade_id   as "Paygrade",
			  rate          as "Rate",
			  ssn           as "SSN",
			  start_date    as  "Start Date",
			  stop_date     as  "Stop Date",
			  username      as  "Username",
			  view_sens_ind as "Sensitive")))

from sams.provider

returns .....

XMLELEMENT("PROVIDER",XMLATTRIBUTES('09.01.00'AS"VERSION"),XMLELEMENT("HEADERINF


<provider

version="09.01.00"><HeaderInfo><entity_seq>855</entity_seq><facility_u

<provider

version="09.01.00"><HeaderInfo><cmd_seq>860</cmd_seq><corps_id>HC</cor

<provider

version="09.01.00"><HeaderInfo><cmd_seq>860</cmd_seq><corps_id>BSC</co

<provider

version="09.01.00"><HeaderInfo><cmd_seq>860</cmd_seq><corps_id>HC</cor

<provider

version="09.01.00"><HeaderInfo><cmd_seq>860</cmd_seq><corps_id>MC</cor

<provider

version="09.01.00"><HeaderInfo><cmd_seq>860</cmd_seq><corps_id>HC</cor

<provider

version="09.01.00"><HeaderInfo><cmd_seq>860</cmd_seq><corps_id>HC</cor

<provider

version="09.01.00"><HeaderInfo><cmd_seq>860</cmd_seq><corps_id>MC</cor

.... ( 23 rows returned ) Received on Thu May 26 2005 - 11:02:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US