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 -> Re: How do I format this query to see each XML document from start to end?

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

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 27 May 2005 04:54:14 -0700
Message-ID: <1117194854.615402.316410@g14g2000cwa.googlegroups.com>


thanks for the response,
Im not worried about the result being formatted like I wrote in psudo xml I just want the complete document to adhere to the psuedo xml's schema.
I just wanted all my rows to be inside of the <Provider> </Provider> tags.
Not a <Provider> </Provider> for each row. thats all.

I think I need to think more about the query first then SQLX functions next.

I may use a User Defined Type to get the format I want for the more complex queries.
Just dont want to have a UDT for each table. I would like to get it with just a query.

IF somebody writes a good SQLX book it will have good sales.

I see threads with some of the same "fuzziness" on certain uses of SQLX. Received on Fri May 27 2005 - 06:54:14 CDT

Original text of this message

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