Confusion with Oracle CONNECT BY
The query:
select level from dual connect by rownum<10;
gives numbers from 1 to 9.
Another query:
SELECT LEVEL FROM DUAL CONNECT BY rownum>5;
outputs: 1
I have used CONNECT BY in hierarchical data like manager/employee. But I
fail to interpret the results of the above two queries.
No comments:
Post a Comment