Answer Posted / asdasd

SELECT min(gross) FROM(SELECT distinct(gross) FROM
srbs_staff_pay_dtls ORDER
BY gross DESC) WHERE ROWNUM<=4;

How to fetch the row which has the max value for a column?

994

---

What is a directory object?

1089

---

What are the predefined tablespaces in a database?

1077

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2056

---

What is logical backup in oracle?

1013

---

How to start an oracle instance?

1015

---

Describe an oracle table?

1047

---

Explain the use of record option in exp command.

996

---

What is literal?

997

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2214

---

what are the default admin accounts in Oracle 10g ?

964

---

What are the different types of record groups in oracle? Explain each of them

1022

---

What are the types of trigger in oracle?

974

---

What happens to the current transaction if the session is killed?

982

---

What privilege is needed for a user to insert rows to tables in another schema?

1010

---