Re: xsql

From: Harri Kaukovuo <harri.kaukovuo4_at_nic.fi>
Date: 13 Aug 2002 04:24:55 GMT
Message-ID: <aja1mn$1ld$1_at_news1.song.fi>

Try using the cursor -method in the select statement. Something like this: select f1.a, f1.b, .f1.c,

            cursor (select f2.d from foo2 f1 where f2.key = f1.key) as col4 from foo1 f1

This will result nicely structured XML document, just like you wanted.

Pls see your manual for the syntax. You cannot use cursor in the view but you can use it e.g. in the select statement in XSQL query.

• Harri

ksella76_at_yahoo.co.uk (kella) wrote in news:3c1b130d.0208121656.3ae5e6e4_at_posting.google.com:

> hi,
> does xsql allow for nested multiple sql queries, such as:
>

><?xml version="1.0"?>
><xsql:query xmlns:xsql="urn:oracle-xsql" connection="hele">

> SELECT * FROM Region

><xsql:query xmlns:xsql="urn:oracle-xsql" connection="hele">

> SELECT * FROM Company

></xsql:query>
></xsql:query>

>
> And if so, is it possible for results from an earlier query to be
> used elsewhere such as:
>

><?xml version="1.0"?>
><xsql:query xmlns:xsql="urn:oracle-xsql" connection="hele">

> SELECT regionname FROM Region

><xsql:query xmlns:xsql="urn:oracle-xsql" connection="hele">
><!-- regionname below is the regioname from above -->

> SELECT companyname FROM Company where regioname=regionname

></xsql:query>
></xsql:query>

>
>
> Thanks
>
> jim
>

-- 
-----------------------------------------------------------------------
Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4

Received on Tue Aug 13 2002 - 06:24:55 CEST