Re: 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 14:44:35 -0700
Message-ID: <1117143875.925776.193330@z14g2000cwz.googlegroups.com>

I figured out I need to set long, my real goal was to get my format to be like what I listed in my second post instead I get

SQL> select xmlelement( "provider",

  2                xmlattributes( '09.01.00' as "version"),
  3                          xmlelement("HeaderInfo",
  4                          xmlforest(cmd_seq as "cmd_seq",
  5                                 corps_id  as "corps_id",
  6                                     dea_id as "dea_id",
  7                              entity_seq as "entity_seq",
  8                        facility_uic as "facility_uic")),
  9          xmlelement("Detail",
 10       xmlforest(fname||' '||lname||''||suffix as "Name",
 11                       paygrade_id   as "Paygrade",
 12                        rate          as "Rate",
 13                      ssn           as "SSN",
 14                     start_date    as  "Start Date",
 15                     stop_date     as  "Stop Date",
 16                     username      as  "Username",
 17                     view_sens_ind as "Sensitive")))
 18        from sams.provider order by cmd_seq;

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

<provider

version="09.01.00"><HeaderInfo><cmd_seq>860</cmd_seq><corps_id>HC</cor ps_id><entity_seq>861</entity_seq><facility_uic>00000000</facility_uic></HeaderIn fo><Detail><Name>CHRIS
BOYLES</Name><Paygrade>CIV</Paygrade><Rate>CIV</Rate><SS N>001010001</SSN><Start_x0020_Date>01-JAN-00</Start_x0020_Date><Username>QUACK_1 67</Username><Sensitive>Y</Sensitive></Detail></provider>

I want
<Provider version="9.01">

     </Detail>
     ( a header and detail for each row, all rows enclosed in Provider

tags )
</Provider>

any ideas? Received on Thu May 26 2005 - 16:44:35 CDT