Answer Posted / kamal

step 1=write a query for maximum salary.
step 2=make a sub query of step 1
step 2 a)let X==sleect all row from your table(employee)
b)let Y=select maximum salary from employee
NOw c)wrie X-Y


Syntax is:
select MAX(salary) from employeee((select * from
employee)-(selcect MAX(salary) from employee))

What is Java Pool in Oracle?

1234

---

Explain the use of indexes option in exp command.

1206

---

What is the difference between pre-select and pre-query?

1295

---

Can we call procedure inside function in oracle?

1147

---

What is the database name in oracle?

1076

---

What is oracle database client?

1080

---

various types of hints and their usage

2746

---

How to convert a date to char in oracle? Give one example.

1106

---

Explain rename?

1041

---

Calculate difference between 2 date / times in oracle sql?

1097

---

What is an oracle?

1063

---

How to use values from other tables in update statements using oracle?

1120

---

What is logical backup in oracle?

1081

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1048

---

How to insert a new row into a table in oracle?

1213

---