CODEWITHSUNDEEP
sqloracle-database
Oleksandr Samsonov
Oleksandr Samsonov

Reputation: 1097

CONNECT BY PRIOR

How to break out query on third nesting?

 SELECT CHILD_ID
   FROM COLLECTION_ITEMS 
  START WITH PARENT_ID = 16917 
CONNECT BY PRIOR CHILD_ID = PARENT_ID

I have such query and if nesting rise to more then three I must end query.

Upvotes: 1

Views: 114

Answers (1)

tvm
tvm

Reputation: 3449

You can use LEVEL pseudocolumn.

SELECT
  CHILD_ID
FROM
  COLLECTION_ITEMS
WHERE
  LEVEL <= 3
  START WITH PARENT_ID      = 16917
  CONNECT BY PRIOR CHILD_ID = PARENT_ID

Upvotes: 3

Related Questions