Hi, Can any one help me with an idea, how I can do a recursion for this issue. Thanks.
Rick Hillegas-2 wrote: > > Vrin26 wrote: >> Hi, >> >> I need to do a recursive query on a single derby database table. >> In Derby database documents it is mentioned that this derby doesn't >> support >> recursive queries. >> Is there any other work around to handle this scenario? >> >> Thanks >> >> > You can push the recursion into a table function or into a database > procedure which returns a result set. The table function documentation > talks about wrapping external data sources, but you can also use table > functions to wrap complicated processing inside Derby itself. See > http://db.apache.org/derby/docs/10.5/devguide/devguide-single.html#cdevspecialtabfuncs > > The CREATE PROCEDURE statement is documented here: > http://db.apache.org/derby/docs/10.5/ref/ref-single.html#crefsqlj95081 > > Hope this helps, > -Rick > > -- View this message in context: http://www.nabble.com/Recursive-query-on-common-table-tp25819772p25906990.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
