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
3 matches
Mail list logo