Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> xsql and nested sql queries

xsql and nested sql queries

From: kella <ksella76_at_yahoo.co.uk>
Date: 12 Aug 2002 17:55:38 -0700
Message-ID: <3c1b130d.0208121655.1af13c88@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 Received on Mon Aug 12 2002 - 19:55:38 CDT

Original text of this message

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