| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> How do I format this query to see each XML document from start to end?
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")))
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
![]() |
![]() |