Nested queries in function

From: <buurd_at_my-deja.com>
Date: Tue, 23 Nov 1999 09:31:15 GMT
Message-ID: <81dmt4$ho9$1@nnrp1.deja.com>

Hi!
I have a function that should look like this in some pseduo languange. How to do this function in pl/sql
----------- START --------------

theResult;

topQuery = select row from topTable;
while(topQuery.hasMoreRows){
subQuery = select row1 from subtable where row2=topQuery.row; append subQuery to theResult
}
return theResult;
----------- END ---------------
Tia
--
Roland Carlsson
Certified Java programmer
Skövde
Sweden

ps: To X-mas I want a sql-expert

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 23 1999 - 03:31:15 CST