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;

Can we use pl sql in sql server?

0 Answers  

---

What data types does pl/SQL have?

3 Answers  

---

how can we repair a mysql table? : Sql dba

0 Answers  

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

Does mysql_real_escape_string prevent sql injection?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

What is pl sql in dbms?

0 Answers  

---

When is the explicit cursor used ?

0 Answers  

---

what is the difference between implicit conversions and explicit conversions?

2 Answers  

---

How many primary keys can a table have?

0 Answers  

---

What are the two types of periodical indexes?

0 Answers  

---