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 the difference between a hot backup and a cold backup in oracle?

1079

---

What is pragma autonomous transaction in oracle?

1125

---

Why do we use coalesce function in oracle?

1169

---

How many data types are supported?

1140

---

What is the oracle implicit cursor?

1113

---

How to create a table index?

1230

---

What are the differences between interval year to month and interval day to second?

1067

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

2002

---

How to define an external table with a text file?

1128

---

IS it possible to built the oracle database without setting the kernal parameters?

2397

---

What's dateware house and what's clustor with practicle example

2237

---

Explain oracle’s system global area (sga).

1189

---

What are operators in oracle?

1103

---

How to connect to the server with user account: sys?

1063

---

How to create a table interactively?

1167

---