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?
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