Oracle Database and Oracle Applications
Search This Blog
Tuesday, May 22, 2012
Check Cycle in Position Hierarchy
SQL
>
select
empno
,
mgr
,
connect_by_iscycle
from
scott.emp
connect
by
nocycle mgr
=
prior empno
start
with
empno
=
7321
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment