Message-ID: <3E382873.9010005@netscape.net>
From: Frank <fvanbortel@netscape.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20021120 Netscape/7.01
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle
Subject: Re: Oracle XSU
References: <bc8c7120.0301281008.2f239109@posting.google.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 29
Date: Wed, 29 Jan 2003 20:16:03 +0100
NNTP-Posting-Host: 217.121.193.81
X-Complaints-To: abuse@home.nl
X-Trace: zwoll1.home.nl 1043867143 217.121.193.81 (Wed, 29 Jan 2003 20:05:43 MET)
NNTP-Posting-Date: Wed, 29 Jan 2003 20:05:43 MET
Organization: @Home Network


Asif Kazi wrote:
> Hi,
> I have a table which contains my name and address.
> 
> Name    Street    City      Zip      Phone
> Asif    Pine St.  Vermont   94582    XYZ-PQR-STU
> 
> Is it possible to create the following structure using Oracle XSU.
> 
>      <Person>
>          <Name>Asif</Name>
>          <Address>
>              <Street>Pine St.</Street>
>              <City>Vermont</City>
>              <Zip>94582</Zip> 
>              <Phone>XYZ-PQR-STU</Phone>
>          </Address>
>      <Person>
> 
> Your help would be appreciated.
> Thanks and Regards,
> Asif

XSQL will return just that when the request would be
select * from <table>;
You will need the XSQL servlet, though.

Frank