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
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
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
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'
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
_
5 matches
Mail list logo