Re: [sqlite] Hierarchical Queries with Looping in SQLite DB

2017-07-06 Thread Jean-Luc Hainaut
On 06/07/2017 08:08, Ashif Ahamed wrote: When there is some data bringing looping scenario : *INSERT INTO FOLDER VALUES(2, 'Loop Data', 5);* After inserting this loop data , when i trigger the above recursive query in SQLite it keeps on running without bringing any results. Note: In oracle

Re: [sqlite] Hierarchical Queries with Looping in SQLite DB

2017-07-06 Thread Clemens Ladisch
Ashif Ahamed wrote: > I 'm trying to achieve , oracle's hierarchical CONNECT BY NOCYCLE PRIOR in > SQLite database hierarchical queries i.e. with clause queries(common table > expression) > > When there is a loop in the data ,with clause queries in SQLite database is > running for long with infinit

[sqlite] Hierarchical Queries with Looping in SQLite DB

2017-07-06 Thread Ashif Ahamed
I 'm trying to achieve , oracle's hierarchical CONNECT BY NOCYCLE PRIOR in SQLite database hierarchical queries i.e. with clause queries(common table expression) When there is a loop in the data ,with clause queries in SQLite database is running for long with infinite loops Consider the below sam

Re: [sqlite] hierarchical queries

2008-11-09 Thread Kees Nuyt
On Sun, 9 Nov 2008 20:39:23 +0100, "Sébastien Roux" <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database : >Hi, > >Is there a way of doing hierarchical queries with SQLite. I'm not a killer >with SQL language but I've seen that there are some hierarchical functions >under Oracle. >I'

[sqlite] hierarchical queries

2008-11-09 Thread Sébastien Roux
Hi, Is there a way of doing hierarchical queries with SQLite. I'm not a killer with SQL language but I've seen that there are some hierarchical functions under Oracle. I'm having a hierarchy stored as a parent/child relationship. Thanks for your help. Sébastien Roux _