Answer Posted / manoj

SELECT employee_id, employee_name, salary FROM employees
where rownum < 6 ORDER BY
salary DESC
group by department_id;

What is translate in oracle?

1051

---

master table and child table performances and comparisons in Oracle ?

2071

---

What is archive log in Oracle?

1071

---

How to use like conditions in oracle?

996

---

What is meant by an index?

1060

---

What do you understand by database schema and what does it hold?

1180

---

Explain the use of constraints option in exp command.

993

---

How to call a stored function in oracle?

953

---

What is an oracle data file?

1039

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5333

---

How to shutdown your 10g xe server from command line?

1015

---

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....

2004

---

How to create a new oracle data file?

972

---

What is the dynamic sql in oracle?

1009

---

What is difference between truncate and delete?

977

---