Hierarchical View

[KGP]

Can someone Help me in this?

1. I have one view contains 3 SELECT queries join with UNION

2.All 3 contain START WITH & CONNECT BY

3.This view returns me few rows, If I use filter condition(where clause) then data doesn't get filtered.

4.If I remove START WITH & CONNECT BY from all 3 then it works
OR
Single SELECT query with START WITH & CONNECT BY then it works

Regards
KGP

[Dave44]

to answer this we need to see the tables, some data and the query for the view. then we can help you with what is wrong.

without more information there isnt much to say about it except it doesnt appear to be doing what you want...