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

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1074

---

How to create an initialization parameter file?

1049

---

How to use subqueries in the from clause in oracle?

1111

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1145

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2093

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1949

---

What is the relation of a user account and a schema in oracle?

1080

---

What are the parameters that we can pass through a stored procedure?

1064

---

What are the built-in functions used for sending Parameters to forms ?

3384

---

How a tablespace is related to data files?

1109

---

What is an oracle transaction?

1144

---

What are the differences between char and nchar in oracle?

1094

---

How remove data files before opening a database?

1072

---

What is the oracle implicit cursor?

1062

---