I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!

1 Answers  

---

Tell me New Feature of Oracle 10g?

5 Answers   Thermotech,

---

what are the different types of cursors? explain?

4 Answers  

---

What is a data lock in oracle?

0 Answers  

---

What to do if dba lost the system password?

0 Answers  

---

What is the max number of columns in an oracle table?

0 Answers  

---

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,

---

What is the difference between Delete, Truncate and Drop in Oracle?

0 Answers   MCN Solutions,

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

3 Answers   Satyam,

---

How to empty your oracle recycle bin?

0 Answers  

---

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

3 Answers   Wipro,

---