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;

How do I view a table in sql?

999

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1002

---

What is an inconsistent dependency?

1043

---

Explain the structure of pl/sql in brief.

1080

---

How do I start sql from command line?

1015

---

What is the difference between sql and isql*plus?

1085

---

What is database migration?

961

---

What is spool?

1045

---

what are date and time data types in mysql? : Sql dba

960

---

What are the two types of exceptions.

1156

---

How do you change a value in sql?

1007

---

What packages(if any) has oracle provided for use by developers?

5797

---

Why is normalization important?

1019

---

explain access control lists. : Sql dba

990

---

How to test for null values?

1038

---