Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> xsql and nested sql queries
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
![]() |
![]() |