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;

How many file formats are supported to export data?

1220

---

What are a cluster and non-cluster index?

1018

---

What is pragma autonomous transaction in oracle?

1070

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1048

---

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.

1849

---

How to define a record variable to store a table row?

1058

---

How to delete a user account in oracle?

975

---

What are the differences between blob and clob in oracle?

1089

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2138

---

What is the relation of a user account and a schema?

1134

---

How many data types are supported?

1080

---

What are the extensions used by oracle reports?

1038

---

How to use like conditions in oracle?

1056

---

How to use "if" statements on multiple conditions?

1174

---

How to start your 10g xe server?

1042

---