Answer Posted / siddharth mitra

select *
from (select row_number() over (order by salary asc) as
"ROW_NUM" from emp)
where ROW_NUM = 3;

This only works with oracle 8i and 9i,i.e., row_number is an
analytic function.

What are the differences between interval year to month and interval day to second?

1026

---

How to synchronize 2 schema's objects?

2178

---

What do you understand by a database object?

1057

---

What is the max number of columns in an oracle table?

999

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2103

---

types of indexes and the rationale behind choosing a particular index for a situation.

2510

---

How to insert a record into a table?

1066

---

How to do a full database export?

1106

---

What is ceil and floor in oracle?

1069

---

Is oracle the best database?

963

---

State and explain the different types of data models?

938

---

What is difference between truncate and delete?

1040

---

How many memory layers are in the oracle shared pool?

1179

---

What is the data type of dual table?

991

---

How to turn on or off recycle bin for the session?

1105

---