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.

Is oracle an operator?

932

---

Describe the types of sub query?

1006

---

How to add a new column to an existing table in oracle?

1143

---

What are dml statements in oracle?

1098

---

How to retrieve the count of updated rows?

1132

---

How can we create the complete backup of data in the oracle.

2161

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1023

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1861

---

What is archive log in Oracle?

1137

---

How do I uninstall oracle client from windows?

1018

---

How to define a data source name (dsn) in odbc manager?

1040

---

What is data type in oracle?

1129

---

What is partitioned table in Oracle?

1197

---

Explain what are the uses of rollback segment?

1021

---

How to load data from external tables to regular tables?

1066

---