What is the sql query to find the employee who has Nth maximum salary?

2 Answers  

---

How can you rebuild an index?

1 Answers  

---

Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,

---

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers   Cap Gemini,

---

---

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

How many segment are present in Oracle Manufacturing

0 Answers   Oracle,

---

how to replace not in with not exist?

0 Answers   IBM,

---

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  

---

How do you create a credit note against an invoice? : oracle accounts receivable

0 Answers  

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

---