Answer Posted / gvmahesh
NOCYCLE keyword is default in sequences.
CYCLE :If we want use cycle keyword first we check the table
having primary key or not.If there is no primary key we
absolutely use the CYCLE keyword.
In hierarchical structure,the descendant act as a
ancestor,is called CYCLE.
For eliminating ancestor descendant problem we use NOCYCLE
KEYWORD.
for example we take the EMP table
In EMP table the MGR column has a NULL managerial number.In
that column we insert some of the empno.Then ancestor
descendant problem occur.
select * from emp;
update emp set mgr=7566 where mgr is null;
Then we write a hierarchical query
select empno,ename,sal,mgr from emp
start with ename='KING'
connect by prior empno=mgr;
we execute this query it shows an error
ERROR:
ORA-01436: CONNECT BY loop in user data.
in this situation also we want to see the data through
NOCYCLE keyword.
select empno,ename,sal,mgr from emp
start with ename='KING'
connect by NOCYCLE prior empno=mgr;
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is function and procedure?
How many types of keys are there in sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
What is sql deadlock?
Why indexing is needed?
What is materialized view in sql?
What is varchar used for?
What are the types of variable use in pl sql?
What are the different types of dbms?
What are the types pl/sql code blocks?
Which command is used to delete a package?
What are operators available in sql?
What is a delimiter in sas?
how to rename an existing table in mysql? : Sql dba
What is a common use of group by in sql?