Answer / tulsi

NO CYCLE is default when sequence is created

CYCLE statement is given when the sequence has to repeat
its number generation between START WITH and MAX VALUE.

Answer / 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;

What does the acronym acid stand for in database management?

0 Answers  

---

Does varchar need length?

0 Answers  

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

Can primary key be changed?

0 Answers  

---

How many sql statements are used? Define them.

0 Answers  

---

how to retrive only second row from table?

31 Answers   IBM,

---

wtite down triggr not any entry on Sunday

2 Answers   NIT,

---

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

---

Is full outer join same as cross join?

0 Answers  

---

What's the difference between a primary key and a clustered index?

0 Answers  

---

Why do we create views in sql?

0 Answers  

---