Answer Posted / shiv prakash

select salary from(select rownum as r,salary from(select
rownum,salary from emp order by salary
desc))where r=2;

What is data file?

1150

---

Can we insert data in view oracle?

1119

---

What is a table in oracle?

1022

---

How to write an inner join with the where clause in oracle?

1089

---

How to delete a column in an existing table in oracle?

1127

---

What is a table index in oracle?

1185

---

What is an Oracle Instance?

1163

---

How to connect to a local oracle 10g xe server?

1032

---

What is a user role in oracle?

1184

---

Explain the dml?

1051

---

How to create an initialization parameter file?

1106

---

What is a table index?

1168

---

What is save point in oracle database?

1365

---

How to use existing values in update statements using oracle?

1111

---

How to count duplicated values in a column in oracle?

1106

---