Answer Posted / valli

select rowid from (
select emp_no, rownum() over (emp_no) as Rownum
from emp order_by emp_no,sal
) where rownum > 2

If this query returns no rows then we can say all the emp
numbers are indeed unique.

Regard,
Valli

What is trigger point?

996

---

What are sql functions? Describe in brief different types of sql functions?

1104

---

What is the use of %rowtype?

1041

---

Explain the uses of control file.

1050

---

what are the different type of sql's statements ? : Sql dba

926

---

Is nosql faster than sql?

1023

---

How to avoid using cursors?

1122

---

Why self join is used in sql?

977

---

How can we store rows in PL/SQL using array?

1220

---

What is hibernate and its relation to sql?

1124

---

Explain sql data types?

1101

---

What is an implicit commit?

1058

---

What is sql profiling in oracle?

1065

---

how to enter characters as hex numbers? : Sql dba

1041

---

Can you load data into multiple tables at once? : aql loader

1066

---