SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connect by loop in user data

1003231Apr 22 2013 — edited Apr 22 2013

Dear all,

could anyone please let me know the reason that why i'm getting error ''*Connect by loop in user data*'' for the following query

SELECT distinct AAGTNO,GSM_CODE,AM_CODE
from ext_lsp_ptaagr09
START WITH AAGTNO = '13857'
CONNECT BY PRIOR AAGTNO = gsm_code

i am using 11g database.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2013

Added on Apr 22 2013

#11g

6 comments

408 views